Hi there,
I am getting error run time error on the below code. I am not sure what I need to do to remedy the issue.
Please Login or Register to view this content.
Hi there,
I am getting error run time error on the below code. I am not sure what I need to do to remedy the issue.
Please Login or Register to view this content.
I believe the error is coming up because the code tries to get the value of a range that does not exist... meaning sheets("Sheet").range("A:A").find.... is not finding anything, so that range has no .value property. Try testing to see if the match actually exists...:
this sets the range "tester" to be the cell in sheet2, col A to the one where the matched value was found, and if it is nothing then it just moves on.Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks