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!
|