View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Marc[_3_] Jean-Marc[_3_] is offline
external usenet poster
 
Posts: 1
Default 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