Copy print areas to new worksheet

[Jefe]

I have already posted this thread on Mr.Excel.

I have a file where I have defined the print area and the size of each page. I have written a macro to copy over the values and format, but also need to copy the defined print areas. This file of values then gets exported to another file to mail over Outlook where the print areas need to be copied as well.

Please Login or Register  to view this content.

[daffodil11]

Please Login or Register  to view this content.

As for when you copy the entire worksheet into a new workbook, the Print Area will automatically go with that.