Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2016 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through June 02, 2016 * Excel VBA Macro experts < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 146782
Registered: 03-2004
Posted From: 205.145.107.52

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, May 27, 2016 - 9:04 am:    Edit Post Delete Post Print Post

naaku time leedhu bro, leepothe kelikevaadini ekkadoo function vundi vuntadhi like object.getDefaults(x,x) or setDefaults type loo...
Top of pagePrevious messageNext messageBottom of page Link to this message

Naatarai
Pilla Bewarse
Username: Naatarai

Post Number: 526
Registered: 11-2004
Posted From: 165.225.98.91

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, May 26, 2016 - 6:21 pm:    Edit Post Delete Post Print Post

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.

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration