VBA Vlookup issue

[cstimart]

I am trying to use a vlookup to determine if a value is present..

Dim spot(1 to 2) as Variant
.
.
spot(1) = WorksheetFunction.VLookup(CLng("99999999"), Range("B:B"), 1, False)

Then, I use IsNumeric to determine whether a value or an error is returned. However, when the value isn't present, I get "Unable to get the VLookup property of the WorksheetFunction class" error.

Any ideas

 

[VoG]

Try

spot(1) = Application.VLookup(CLng("99999999"), Range("B:B"), 1, False)

 

[cstimart]

Try

spot(1) = Application.VLookup(CLng("99999999"), Range("B:B"), 1, False)

Can you explain the difference between using application vs. worksheetfunction?

 

[VoG]

Have a read here http://www.dailydoseofexcel.com/archives/2004/09/24/the-worksheetfunction-method/