Vlookup Error in Visual Basic

  • Thread starter Thread starter brett.kaplan
  • Start date Start date
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!
 
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
visual basic book in india 1
Selecting an unmatched value 1
Multiple VLOOKUPS 4
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
using vlookup for multiple files 6
Vlookup Error 0
VLOOKUP problem 3

Back
Top