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!