I am trying to select multiple/two sheets like: Sheets(Array("AAA", "BBB").Select
There will be different number of sheets in workbook with different names each time the macro is run.
I have function which creates names in string with all the formatting: "AAA", "BBB" and shows it in cell A1 or it could by all typed into the cell.
Is there any way for below to work?
"AAA", "BBB" typed into A1
Sub
Dim CCC As .....
CCC = Range("a1").Value
Sheets(Array(CCC).Select or Sheets(CCC).Select
End
It works fine with one sheet - eg "Sheet1" or "AAA" but it does not like the format with multiple sheets "Sheet1", "Sheet2" .
What do I need to do with CCC = Range("a1").Value .
Bookmarks