fix switch view....

[J.W. Aldridge]

Need two columns to be hidden based on macro button.
I got the following formula from a previous question and adapted it by
adding a second column (L:L) to fit my needs but it only does L:L and
not K:K

Any help?

Sub SwitchView()
With ActiveSheet.Range("K:K,L:L").EntireColumn
.Hidden = Not .Hidden
End With
End Sub


thanx

 

[Ron de Bruin]

Use it like this

Sub SwitchView()
With ActiveSheet.Range("K:L").EntireColumn
.Hidden = Not .Hidden
End With
End Sub

 

[J.W. Aldridge]

Scratch that... Got it to work!

Thanx anyways!