Macro: how can I select multiple sheets in a workbook?

Question

The workbook has over 50 worksheets and I'm working through an old macro that will help me amend the same range within each sheet. Howvere they have ahrdcoded the sheets.selectstatement.

How do you write: Sheets(Array("Sheet1", "Bob", "1953", etc, etc, etc)).Select so that all the sheets are selected - from first to last, no matter what name someone has given them?

Many thanks

Mike

Answer 1

ThisWorkbook.Sheets.Select