Hi, I am trying to get the following working:


If Application.WorksheetFunction.IsNA(Application. _
WorksheetFunction.VLookup(lookUpValue,
myRange, 1, False)) = False Then

I have tested it where it should not be able to find
anything from the vlookup and it causes an error of 1004
unable to get the vlookup property of the worksheet class.

How would I go about getting this to work?

Thanks,
Grant.