Yes, you have to copy each setting (unless you copy the sheet itself).

Don didn't put in double dots. Some mail software puts in a dot if there is
a dot on the left margin. Otherwise the single dot is interpreted as a
formatting command.

--
Regards,
Tom Ogilvy

"Robin Clay" wrote in message
...

Erm... Thanks, but... it didn't like the double dots, so I
deleted one of them.

And it didn't copy the entire layout - the orientation
remains the same - they were both landscape, anyway.

Is there a "blanket" command that will copy everything, or
do I really have to copy every single individual item in
turn ?


-----Original Message-----
try this for the setups you want

Sub copysetup()
With ActiveSheet.PageSetup
..Orientation = Sheets("sheet7").PageSetup.Orientation
End With
End Sub


"Robin Clay" wrote
in message
...
Greetings !

How do I copy the Page SetUp from one Worksheet to
another ?

I do NOT want to copy it to all sheets.

I'm sure it's a very simple thing, something like

Worksheets(7).PageSetUp = Worksheets(1).PageSetUp
RunTime Error 438:
Object doesn't support this property or method

I also want to copy the Header & Footer -
would they be included?

RClay AT haswell DOT com


.