In the code below I would like to change the statement to paste as values and format. When the macro runs now it pastes as values but not the format. Can anyone help?
Please Login or Register to view this content.
In the code below I would like to change the statement to paste as values and format. When the macro runs now it pastes as values but not the format. Can anyone help?
Please Login or Register to view this content.
Last edited by Leith Ross; 03-18-2010 at 04:57 PM.
Hello rhudgins,
Here is the revised code. The PasteSpecial has to be done twice on the range, once for values and again for formats.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks! In addition in the attached excel sheet I would like to add a code that copies the values on the data tab from column C and D to the sheet1 tab in cells F7 and F9. Can you help me with this?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks