Copying page setup information

[tbjohnson2]

Is there anyway to copy/paste the page setup information
from one worksheet to another? I am creating a new
worksheet via VBA code and would like to copy the print
information over. I can not just copy the whole worksheet
to another workbook as there are linked formulas that can
not be copied. I am also copying multiple worksheets at
the same time (via an array) and each worksheet has
different page setups (page margins, etc.)

Any help would be greatly appreciated.

Thanks!

 

[Tom Ogilvy]

See one answer to your multi-posting of this question in
Worksheet.Functions. That answer is a manual method. For code, you need to
do each sheet individually by making the appropriate settings. You can't
copy.