It sure would be nice if it did. But I betting it didn't work when you tried
it, huh?

Steven Cheng wrote:

I believe that I should be able to "pass" the parameter settings of one
pagesetup on a worksheet to another and thus having the same headers,
footers, margins, print areas and such without having to declare each
setting....

private sub setupworksheetprintarea()

dim w as worksheet
dim wkb as workbook
dim pg as pagesetup

set w = thisworkbook.activesheet

set wkb = workbooks.add

set wkb.activesheet.pagesetup = w.pagesetup

end sub

I am only speculating but I think it should work...

--

Dave Peterson