Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Naatarai Pilla Bewarse Username: Naatarai Post Number: 526 Registered: 11-2004 Posted From: 165.225.98.91 Rating: N/A Votes: 0 Posted on Thursday, May 26, 2016 - 6:21 pm:    I have a macro that generates a number of worksheets in an excel workbook. I have page setup options which fit all columns to one page, make the orientation landscape,etc. The macro also emails each of these sheets to different users as a new workbook for each sheet. However, when try to copy the worksheets into a new workbook before emailing, the page setup options are not getting copied. What I would like to do is that the sheets being emailed to users need to keep the formatting & page setup of the original sheet. Would really appreciate any help.