I am trying to use a vlookup to determine if a value is present..
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
Code:
Dim spot(1 to 2) as Variant
.
.
spot(1) = WorksheetFunction.VLookup(CLng("99999999"), Range("B:B"), 1, False)
Any ideas