Thread
:
Selecting all of the sheets in a workbook
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Selecting all of the sheets in a workbook
sheets.select
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Cyberwolf" wrote in message
...
How would I go creating a macro or VBA that selects all of the worksheets
in
a given workbook. This needs to work regardless of how many sheets there
are.
i.e.
workbook1 may contain 5 worksheets where as workbook2
may
contain 8.
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett