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
精彩评论