Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page set-up when selecting multiple sheets
Hello there,
Having problems when writing macro and wishing to set-up a number of sheets for print in the same format. The following statement only returns the appropriate set- up for the first sheet, in the example below, the Finalised Sheet. Sheets(Array ("Finalised", "Swanley", "Plant", "STRTU")).Select With ActiveSheet.PageSetup Have I discovered a bug or is there a fix ? Thanks in advance, Jean-Marc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Multiple Sheets in VBA | Excel Worksheet Functions | |||
selecting different cell ranges across sheets, to display on summary page | Excel Discussion (Misc queries) | |||
selecting multiple sheets | Excel Worksheet Functions | |||
selecting multiple sheets | Excel Programming | |||
Changing the value in multiple sheets without selecting those sheets | Excel Programming |