View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dawn Bjork Buzbee Dawn Bjork Buzbee is offline
external usenet poster
 
Posts: 10
Default How to Select All sheets

Greetings All!

Simple I'm sure but not obvious:

Every month I generate a group of worksheets that will vary in name and
number.

What is the code to select all of the worksheets so that I can apply a
consistent page setup?

(The only examples I have been able to locate always specify worksheet names.)

Then, with the entire workbook selected, I want to select all cells to apply
consistent formatting.

Thanks in advance!

--
Dawn Bjork Buzbee