LinkBack URL
About LinkBacks
Hello, I'd like to copy the value of the destination vs. the formula in column A2:A. See my code below.
Please Login or Register to view this content.
Hello, I'd like to copy the value of the destination vs. the formula in column A2:A. See my code below.
Please Login or Register to view this content.
Last edited by romperstomper; 06-08-2011 at 11:13 AM. Reason: add tags
Please use code tags when posting code to the forum per the forum rules.
I also don't really follow what you mean.
Dom
Last edited by Domski; 06-08-2011 at 10:22 AM.
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
The current code copys over the cell as is, I'd like to copy or paste special values the value only in the destination column. I have a formula in the copy from range that I'd like to pull values over for.
Something like:
not clear if you needed the same for the other copy?Please Login or Register to view this content.
Note: I have added code tags to your first post - please learn to use them in future when posting code.
Everyone who confuses correlation and causation ends up dead.
Like this:
Please Login or Register to view this content.
Dom
Last edited by Domski; 06-08-2011 at 11:46 AM.
I get ' Run-time error '1004' PasteSpecial method of Range class failed'
On which? Do you have any merged cells?
If it was mine you mean there was a small but significant error which I've now corrected.
Dom
That worked, Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks