Unfortunately, there is no good way to do a multiple PageSetup using VBA
without using a loop, unless you want to use the dreaded SendKeys to
simulate keystrokes.

--

Vasant

"Jean-Marc" wrote in message
...
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