Hi all,
I am trying to make a piece of code to look up a row and paste another row of data as values over the top.
Below is the code as I am trying it. It gets hung up on the last paste row. If someone could please point me in the right direction as I am pulling my hair out trying to make this work!
Please Login or Register to view this content.
Last edited by Ollie7957; 09-27-2016 at 06:28 AM.
Please Login or Register to view this content.
If you are pleased with a member's answer then use the Star icon to rate it.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you both so much. Buran, your simple fix worked perfectly, however I will incorporate elements from Alpha's formula too. Thank you!
You're welcome.Originally Posted by Ollie7957
Thank you both so much. Buran, your simple fix worked perfectly, however I will incorporate elements from Alpha's formula too. Thank you!
Buran's fix corrected one problem, but that code would still throw an error if no match was found.
You are right. I hadn't yet gotten to that part as I was trying to fix this run time error. Thanks again to you both.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks