copy all pagesetup settings?

[cornishbloke]

Hopefully a question with a simple answer (that's how they al
start)...

In VBA is it possible to copy all of the pagesetup setting
(printareas, margins, headers footers... everything) from a sheet i
one workbook to a sheet in another workbook

 

[Ron de Bruin]

No simple answer

Read this answer from Dave Peterson
http://tinyurl.com/3y2uc

 

[J.E. McGimpsey]

Very simple answer: You need to copy the settings property by
property.

Alternative: copy the entire sheet - page setup settings go along
for the ride.

OTOH, accessing the PageSetup object property by property can be
glacially slow, so you might want to take a look at

http://www.mcgimpsey.com/excel/pagesetup.html

which has a macro based on a routine by John Green (which you can
see here:

http://google.com/groups?selm=VA.00000b2f.0028c7e5@mara9