Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group All Sheets in a workbook
Anyone know the code to group all Sheets in a workbook??...trying to do
the same page setup on all sheets in a workbook and need to group them together first. TIA. -mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group All Sheets in a workbook
"Michael Smith" wrote in message ... : Anyone know the code to group all Sheets in a workbook??...trying to do : the same page setup on all sheets in a workbook and need to group them : together first. : : TIA. : -mike Well, not sure exactly what you mean but there are several ways to select worksheets. You can use the sheets collection Sheets.Select to select all sheets or you can iterate throught the collection for each sh in sheets ...code here next sh you could array the sheets Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select I believe .pagesetup is a propert of worksheet only so you either need to group them first then use activesheet or iterate Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name a group of sheets | Excel Discussion (Misc queries) | |||
group excel sheets within workbook | Excel Discussion (Misc queries) | |||
Group Sheets | Excel Discussion (Misc queries) | |||
Need group all sheets in a workbook | Excel Programming | |||
Print group of sheets by VBA | Excel Programming |