开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜