VBA unhide columns

[strud]

Hi guys,

I am very new to VBA and have a basic knowledge.

I need a macro to unhide columns. I have columns hidden in twos- so E:F, H:I, K:L are all hidden.

I want to attach the macro to a command button and the macro initially to unhide E:F only, then H:I, then K:L. So unhide one set of columsn each time the user clicks the same button.

I think it will be some sort of IF function- so if E:F is unhidden then unhide H:I and so on...

I don't know how to do this though...

Any ideas guys?

Thanks in advance...

[ragulduy]

Please Login or Register  to view this content.

[strud]

Thanks Yudlugar, I see, to remember you solved one of my problems the other day as well, so thanks for all your help!!

Much appreciated!

Please Login or Register  to view this content.