| Author |
Message |
    
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 146782
Registered: 03-2004
Posted From: 205.145.107.52
| | Posted on Friday, May 27, 2016 - 9:04 am: |
|
naaku time leedhu bro, leepothe kelikevaadini ekkadoo function vundi vuntadhi like object.getDefaults(x,x) or setDefaults type loo... |
Naatarai
Pilla Bewarse
Username: Naatarai
Post Number: 526
Registered: 11-2004
Posted From: 165.225.98.91
| | 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. |
|
Archives - 2016