How can I select all sheets in a workbook?

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. However they have hardc开发者_开发问答oded the sheets.select statement.

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?

---

ThisWorkbook.Sheets.Select