View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tbjohnson2 tbjohnson2 is offline
external usenet poster
 
Posts: 1
Default 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!