Hi,
I have 2 sets of rows on my sheet (Transactions) that I want to show/hide. Does anyone know how to do that with macros that are independent of each other?
My first range is rows 5 to 17
My second range is rows 19 to 28
I would like to assign these to shapes that will toggle the ranges please.
Thank you very much
PS I have these codes but they don't work independently:
I have 2 sets of rows on my sheet (Transactions) that I want to show/hide. Does anyone know how to do that with macros that are independent of each other?
My first range is rows 5 to 17
My second range is rows 19 to 28
I would like to assign these to shapes that will toggle the ranges please.
Thank you very much
PS I have these codes but they don't work independently:
Code:
Sub ToggleRows1()
With Rows("5:17")
.Hidden = Not .Hidden
End With
End Sub
Sub ToggleRows2()
With Rows("19:28")
.Hidden = Not .Hidden
End With
End Sub
Attachments
Last edited: