I am looking to construct a VBA that unhides specific rows across different sheets in a workbook. I can write separate VBA for each sheet/row combination, but was wondering if I can put them all together instead?
3 sheets need the same rows unhidden that I already have code for:
But I am looking to incorporate these sheets/rows into the code above if possible:
Sheet3 - Rows 11:239
Sheet5 - Rows 23:146
Sheet4 - Rows 11:60
Sheet10 - Rows 28:77
Thank you!
3 sheets need the same rows unhidden that I already have code for:
Code:
Sub Test()
Application.ScreenUpdating = False
Dim wsMySheet As Worksheet
For Each wsMySheet In Sheets(Array(Sheet6.Name, Sheet7.Name, Sheet8.Name))
With wsMySheet
.Rows("26:75").EntireRow.Hidden = False
End With
Next wsMySheet
Application.ScreenUpdating = True
End Sub
But I am looking to incorporate these sheets/rows into the code above if possible:
Sheet3 - Rows 11:239
Sheet5 - Rows 23:146
Sheet4 - Rows 11:60
Sheet10 - Rows 28:77
Thank you!