Hi All
I need a VBA to copy cell referenced in cell B1 to cell referenced in cell B2 as per workbook attached.
Thank you.
Joseph
Hi All
I need a VBA to copy cell referenced in cell B1 to cell referenced in cell B2 as per workbook attached.
Thank you.
Joseph
Potentially would not need copy, the below would be faster if using a lot:
Or are you after taking the range references from the worksheet?![]()
Please Login or Register to view this content.
If things don't change they stay the same
Thank you CheeseSandwich! Sorry, I forgot to mention.. cells referenced in cells B1 and B2 are subject to change.
lol was that a trick, you highlighted J3 but I3 was the destination cell
try:
![]()
Please Login or Register to view this content.
Thanks CheeseSandwich! Works like a charm! And, I have managed to shorten it to:
Here's a Rep for you!![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks