VBA: Hide and Unhide Columns [SOLVED]

[inddon]

Hello There,

I have a block in a worksheet containing 'Merged Columns' and individual cells from D5 to K19.

I have macro which should hide column J. When I run this it hides the whole block from column D5 to K19 and not column J.

Could you please advise, how to achieve the desired result. The merged columns need to be untouched.

Attached is the sample workbook for your reference

Thanks & regards
Don

 

[NARAYANK991]

Hi Don ,

Try this :

Range("J1").EntireColumn.Hidden = True

Narayan

 

[inddon]

Hi Don ,

Try this :

Range("J1").EntireColumn.Hidden = True

Narayan

Hello Narayan,

That worked. Thank you for your help

Could you please tag this post as [SOLVED] for me.



Regards
Don