VBA unhide columns

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...

Sub Macro1()

If Range("E:F").EntireColumn.Hidden = true Then
    Range("E:F").EntireColumn.Hidden = false
ElseIf Range("H:I").EntireColumn.Hidden = true Then
    Range("H:I").EntireColumn.Hidden = false
ElseIf Range("K:L").EntireColumn.Hidden = true Then
    Range("K:L").EntireColumn.Hidden = false
End If

End Sub

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!

Originally Posted by yudlugar

Sub Macro1()

If Range("E:F").EntireColumn.Hidden = true Then
    Range("E:F").EntireColumn.Hidden = false
ElseIf Range("H:I").EntireColumn.Hidden = true Then
    Range("H:I").EntireColumn.Hidden = false
ElseIf Range("K:L").EntireColumn.Hidden = true Then
    Range("K:L").EntireColumn.Hidden = false
End If

End Sub