Below is a macro that selects the following sheets: Main, Index, ResultA1, ResultBB, and Result92.
Sheets(Array("Main", "Index", "ResultA1", "ResultBB", "Result92", "Sheet8")).Select
I need this macro to be a bit more dynamic. Suppose I were to add a new result worksheet names 'Result99'. I would need to manually modify the code above.
Instead, I need a macro that selects 'Main', 'Index', and all sheet names that start with 'Result'. Any suggestions would be greatly appreciated.