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(Cell s(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!

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().

wrote:

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(Cell s(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!

--

Dave Peterson