View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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