Hi, I have a problem.
The relevant part here is that
in my code works as long as there is no error finding a match. If no match is found, the code crashes.Please Login or Register to view this content.
This is the whole function
The code is supposed to add a text from cell A2 next to each entry of "Mallit" column B that is found in "Putket" column A.Please Login or Register to view this content.
So basically the function says: If found match then add the text next to match. If not found, copy the matchless data to cell next to it. Simple right?
I've now deleted the actual functions from the part where an error is found and simply replaced it with a debug msgbox. I don't see the msgbox, instead before that I get "Unable to get the Match property of Worksheetfunction class"
The code does all it's supposed to until the first matchless cell
Bookmarks