A simple but vexing problem. I need to unhide non-consecutive rows &
this is the code I have -
Rows("44:45").Select
Selection.EntireRow.Hidden = False
Rows("47").Select
Selection.EntireRow.Hidden = False
Rows("50:53").Select
Selection.EntireRow.Hidden = False
What I want to do is to group the rows in one line then hide them at
once & I have tried many variations (search XL groups & googled) but
can't get it to work -
'To unhide all Rows in range
Range("44:45, 47, 50:53").EntireRow.Hidden = False
I have had "Runtime error 13" & "mismatch error"