I am trying to use the folowing statement inside a for-next loop

target = Application.WorksheetFunction.VLookup(c.Value, OldRange, 1, True)

It returns run time error 1004 - Unable to get the vlookup property of the worksheetfunction class.

Does anyone recognize this situation and know the solution? Thanks.