T
thunderfoot
Sub ToggleHidingColA()
' TOGGLE BETWEEN HIDING AND UNHIDING ROWS
Rows ("10:32").Hidden = Not (Rows("10:32").Hidden)
End Sub
The above code allows a macro button to toggle Hide/Unhide of Rows 10
to 32 incl.
If Rows 10 to 32 are indentified with a Named Range of 'Level01', how
is the above code ammended to show the Named Range not the row
numbers???
This must be simple, but I'm missing it somewhere!!!!
' TOGGLE BETWEEN HIDING AND UNHIDING ROWS
Rows ("10:32").Hidden = Not (Rows("10:32").Hidden)
End Sub
The above code allows a macro button to toggle Hide/Unhide of Rows 10
to 32 incl.
If Rows 10 to 32 are indentified with a Named Range of 'Level01', how
is the above code ammended to show the Named Range not the row
numbers???
This must be simple, but I'm missing it somewhere!!!!