VBA - Pasting values rather than formulas
Hello fellow Excel users,
I'm struggling to come up with a solution to the below code. It works almost perfectly, but instead of copying formulas from the rows I select, I need the code to paste values.
Any chance that someone could help?
Many thanks in advance!
Please Login or Register to view this content.
Replace your Copy line of code with these two lines
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Maybe this:
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
You both posted the solutions at the very same time - talking about coincidence!
The codes work perfectly, so a big thank you to both of you!
Cheers,
Red
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks