Hi
I nee to do a lot of saving values only once the formula has pulled the result and want to know if there is a way to set this up so I only need to click once, currently I press Copy, Paste then select values only. I can make this fairly quick by using ctrl C, ctrl V and then click values but still think there must be a fater way.
Thnaks
Try this Macro
It will copy the data and paste values at the source..
Please Login or Register to view this content.
If you want to select destination range then try this code..
Totally untested as you haven't provided any workbook..Please Login or Register to view this content.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks