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.
Bookmarks