Hello,
I use this code for a vlookup macro. When it doesnt find the value it gives me the value "#Value".
How can I change this so it leaves the cell blank if there is no match?
Thanks!
Please Login or Register to view this content.
Hello,
I use this code for a vlookup macro. When it doesnt find the value it gives me the value "#Value".
How can I change this so it leaves the cell blank if there is no match?
Thanks!
Please Login or Register to view this content.
Did you try removing this line?
Please Login or Register to view this content.
Try something like this.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Both of those soloutions give me an error when I run the code
Which line gets highlighted when you click on Debug after getting an error msg?
If myCell.Offset(, 1).Value = "" Then
There is nothing wrong in the line of code If myCell.Offset(, 1).Value = "" Then. What error message you get? Better you upload the sample workbook with the code applied.
I found the problem. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks