I try to select multiple sheets, but i always receive Run Time error 9:Subscript out of range.
When i want to select 2 or more fixed sheet i use:
ThisWorkbook.Worksheets(Array("<Sheet name 1>", "<Sheet name 2>")).Select
and it works.
But in my current case the sheets may vary.
So i created a cell with all the names of the sheets that should be selected. In my case Cell G28 on sheet 9.
I tried several posibilities but receive always the same run time error.
Below the code i tested last:
Dim aSheetnames As Variant
aSheetnames = Sheet9.Range("G28").Value
How can i resolve this problem?