Question : Excel VBA hide sheets with names in array
Answered by : daniel-ferry
Sheets(arr).Visible = False
'Note1: For this to work without an error, 'arr' needs to be a 1D array with a
' valid and actual sheet name in each element.
'Note2: An array cannot be used to make sheets visible if they are hidden.
' This array technique only works to hide visible sheets.Source : http://academy.excelhero.com/ | Last Update : Thu, 05 Nov 20