I have hidden some worksheets using xlSheetVeryHidden. Now when I try to unhide a specific sheet, and selecting it, but it keeps giving me a subscript out of range error.
How can I unhide the worksheet.
I've tried
Worksheets("Home-Page").Select
Worksheets("Home-Page").Visible = True
Worksheets("Home-Page").xlSheetVeryHidden = False
Worksheets("Home-Page").unhide = True