Copying page setup information
 

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!

Copying page setup information
 

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.

--
Regards,
Tom Ogilvy


tbjohnson2 wrote in message
...
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!