Another way:
Sheets.Select
or
worksheets.select
(if you want to avoid selecting non-worksheets (like Chart sheets).)
Pank Mehta wrote:
Using a macro how do I group every sheet within a book?
I have created a macro, but find that the names of the sheets will differ
every time and hence I need a mechanism that will automatically select all of
them to allow me to undertake editing within them all at the same time.
--
Dave Peterson
|