View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default fix switch view....

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