Hide Range But Show Some Columns

[ExcelRoy]

Hello everyone,

could I please ask for some help

I need a macro to only show columns C:AE within range C:IN

With C:IN Hidden

Any help much appreciated

 

[HackSlash]

Question unclear. It sounds like you want to hide only AE:IN ... Is that correct?

 

[ExcelRoy]

Hi,

I need the complete range to start hidden (C:IN) then to show only C:AE

I need to switch between 2 variants of this code so I would like C:IN to be hidden to begin with

Thanks

 

[HackSlash]

Just record two macros using the built in macro recorder:

https://support.office.com/en-us/ar...-a-macro-974ef220-f716-4e01-b015-3ea70e64937b

Then open the VBA editor with ALT+F11 and edit your code. Clean it up. Change things and test the code.

This is how I taught myself in the beginning.