ExcelBanter - Excel VBA - Select all sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel VBA - Select all sheets (https://www.excelbanter.com/excel-programming/289551-excel-vba-select-all-sheets.html)

ozcank[_7_]

Excel VBA - Select all sheets

Hi all

Is there a simple macro to select all sheets in a workbook?

Sounds simple but there doesn't seem to be a way.

Thank

--
Message posted from http://www.ExcelForum.com

Shailesh Shah[_2_]

Excel VBA - Select all sheets

Hi,
Try this,

ActiveWorkbook.Sheets.Select

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

All times are GMT +1. The time now is 01:51 PM.