Yes, I know how to unhide multiple hidden pages using a For Next loop. When seems to have me stumped is how to check if a single, specific page is hidden or not?
Regardless of rather sheet "Tiger" is hidden or not, nothing between the IF/END IF works! So clearly my code is not able to actually verify if the specific sheet is visible or not. Any help much appreciated, thx.
Regardless of rather sheet "Tiger" is hidden or not, nothing between the IF/END IF works! So clearly my code is not able to actually verify if the specific sheet is visible or not. Any help much appreciated, thx.
VBA Code:
Dim exportWB As Excel.Workbook
Set exportWB = Workbooks.Open(StrFile)
exportWB.Activate
Worksheets("Tiger").Activate
If Sheets("Tiger").Visible = True Then