Vlookup Error in Visual Basic

B

brett.kaplan

Hi,

I want to check to see if I get an error using VLOOKUP in visual basic.
If I do, I want something to happen; if not, skip over that step.
This is how I have it set up right now:

If IsError(Application.WorksheetFunction.VLookup(Cells(4, 5).Value,
CDSPremiumsRange, 1, False)) = True Then
....

However, when it gets to this step and it is an error, I get a runtime
error message instead of it going to my code for what happens when that
If statement is true. Can someone help??

Thanks!
 
D

Dave Peterson

Drop the .worksheetfunction from your line of code.

Application.worksheetfunction.vlookup() raises a runtime error if there's no
match.

Application.vlookup() returns an error that you can check with iserror().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP error in VBA 1
Selecting an unmatched value 1
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
Help With VLOOKUP 2
#VALUE! 10
"Unable to get the VLookup property of the WorksheetFunction class 4
Multiple VLOOKUPS 4
problem with Vlookup in macro 2

Top