Excel VBA - Select all sheets

ozcank · Jan 29, 2004

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

Shailesh Shah · Jan 29, 2004

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!