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