Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to turn off Page Layout View as default view | New Users to Excel | |||
How do I view color onscreen (it shows up in print view only) | Excel Discussion (Misc queries) | |||
How to create a button to switch to a custom view | Excel Programming | |||
Switch to worksheet view | Excel Programming | |||
VBA Code to switch view | Excel Programming |