R
Richard
I need a Vlookup program for the general case where there may not be data in
the Vlookup lookup table - i.e. Vlookup returns the NA condition.
Normally I handle this in a worksheet function using the IsNA function.
However, I can't do the same think in a macro program - e.g. I get an error
with the following command when Vlookup returns the NA condition
test =
Application.WorksheetFunction.IsNA(Application.WorksheetFunction.VLookup(lookupvalue, lookuprange, 2, False))
I've also tried the programming error functions IsMissing and IsNull.
the Vlookup lookup table - i.e. Vlookup returns the NA condition.
Normally I handle this in a worksheet function using the IsNA function.
However, I can't do the same think in a macro program - e.g. I get an error
with the following command when Vlookup returns the NA condition
test =
Application.WorksheetFunction.IsNA(Application.WorksheetFunction.VLookup(lookupvalue, lookuprange, 2, False))
I've also tried the programming error functions IsMissing and IsNull.