Hey guys,
I have little knowledge on Macros in excel. I found this macro that I use to copy the content from another workbook to the current one. With trial and error, I made it work.
Please Login or Register to view this content.
However I want it to paste special Values (not the formula). How do I adjust it?
Thank you so much in advance.
Last edited by JBeaucaire; 03-20-2013 at 02:50 PM. Reason: Added code tags, as per forum rules. Don't forget!
To do paste special, the copy and paste needs to be done in 2 lines.
So instead of
It would bePlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by JBeaucaire; 03-20-2013 at 02:53 PM. Reason: Added code tags, as per forum rules. Don't forget!
You're copying and pasting in the same line of code, so that makes it a full copy/paste. To copy and paste values, you'll need to switch to a separate PASTE command.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This is awesome and works great. Thank you for your help!
If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks