Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Select All sheets
Try this...
Sub SelectAllSheets() Dim wks As Worksheet For Each wks In Worksheets wks.Select False Next wks End Sub -- HTH... Jim Thomlinson "Dawn Bjork Buzbee" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Select All sheets
Thanks Jim-I'll try it!
-- Dawn Bjork Buzbee "Jim Thomlinson" wrote: Try this... Sub SelectAllSheets() Dim wks As Worksheet For Each wks In Worksheets wks.Select False Next wks End Sub -- HTH... Jim Thomlinson "Dawn Bjork Buzbee" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheets.select | Excel Programming | |||
select sheets | Excel Programming | |||
How to select other sheets using ADO | Excel Programming | |||
select a1 on all sheets | Excel Programming | |||
select sheets by name - how? | Excel Programming |