I am trying to unhide a range of rows across several worksheets in the same book at once. Here is the code I have:
Sheets(Array("AUG", "SEP", "OCT", "Q1", "NOV", "DEC", "JAN", "Q2", "FALL", "FALL2")).Select
Sheets("AUG").Activate
' Show regular departments
Range("9:30,222:247").Select
Range("A9").Activate
Selection.EntireRow.Hidden = False
Currently, it is only unhiding the rows on the "AUG" tab. Any suggestions? All help is appreciated!
Sheets(Array("AUG", "SEP", "OCT", "Q1", "NOV", "DEC", "JAN", "Q2", "FALL", "FALL2")).Select
Sheets("AUG").Activate
' Show regular departments
Range("9:30,222:247").Select
Range("A9").Activate
Selection.EntireRow.Hidden = False
Currently, it is only unhiding the rows on the "AUG" tab. Any suggestions? All help is appreciated!