Hide columns if visible VBA

[Mr2017]

Hi

I'd like to hide a couple of columns in a sheet, if the columns are visible, without defining additional variables.

I also don't want to use the Sheet name - I'd prefer to use the Sheet number that appears in the VBA editor.

Let's assume the columns are D and M.

And the Sheet is called "Cool Sheet" but is Sheet 4 in the VBA editor.

Does anyone know how to do this?

Thanks in advance.

 

[Fluff]

How about

   Sheet4.Range("D:D,M:M").EntireColumn.Hidden = True

 

[Mr2017]

Awesome!!!

Thanks Fluff!!

 

[Fluff]

You're welcome & thanks for the feedback

 

[Mr2017]

You’re welcome.