VBA Vlookup issue

[cstimart]

I have a macro that opens up a different workbook and uses the worksheetfunction.vlookup to find a value and store it in a variable and then close that workbook.

The problem I am running into is the macro crashing when the vlookup value isn't present in that workbook.

Any ideas for a fix?

 

[Andrew Poulsom]

See if the example here helps:

http://www.mrexcel.com/forum/showthread.php?t=56704

 

[MrKowz]

You need to use an error handling variable for the VLOOKUP, also change it to Application.Vlookup instead of WorksheetFunction.Vlookup. By having it as an Application object instead of a WorksheetFunction object, it returns a trappable error.

Dim x as Variant
x = Application.Vlookup(*your formula here*)
If Not IsError(x) Then
    ' What you want to do when the Vlookup returns a value
Else
    ' What you want to do when the Vlookup returns an error (no value found)
End If