PDA

View Full Version : Solved: Toggle line of code



YellowLabPro
11-04-2008, 08:06 AM
I would like to toggle this, if on, turn off, if off, turn on

Columns("A:F").EntireColumn.Hidden = True

Thanks,

Doug

mikerickson
11-04-2008, 08:12 AM
Columns("A:F").EntireColumn.Hidden = Not(Columns("A:F").EntireColumn.Hidden)
you might prefer
Columns("A:F").EntireColumn.Hidden = Not(Columns("A").EntireColumn.Hidden) to deal with situations where A and B are differently visible.

YellowLabPro
11-04-2008, 08:17 AM
Thanks Mike!