Please help me to modify the part of an complete macro to copy and paste specials (values, columns widths, formats) from sheet2 to sheet3.
I don't want to copy the formulas just the values and the formats.
Please Login or Register to view this content.
Last edited by ccsmith; 11-02-2012 at 03:25 PM.
Try this
Please Login or Register to view this content.
Last edited by arlu1201; 11-02-2012 at 07:05 AM. Reason: Added line to clear clipboard.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You could also try this:
Please Login or Register to view this content.
Last edited by Winon; 11-02-2012 at 06:19 AM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Yet again Winon, if you use the Select & Activate statements, it makes the code slower and the code works more efficiently without them. Hence, my code above does not have any select & activate statements.
@ arlu1201,
Yet again Arlette, I concede, thank you!
But may we please clear the ClipBoard?
Oops yeah Winon. Thanks. Edited the code.
Thanks for your reply.
My only problem is that the height of the rows didn't keep the original source of formatting.
Do you have idea how to keep the height of the rows after copy / paste in the new worksheet?
Hello ccsmith,
Try this Code.
Please Login or Register to view this content.
Last edited by Winon; 11-03-2012 at 03:17 AM. Reason: Corrected Sheet reference
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks