Unable to get the Vlookup property of the WorksheetFunction class

[uktous]

Hi

My macro is correct.

However, sometimes, there is Run-time error ‘1004’. And tell me that “Unable to get the vlookup property of the WorksheetFunction class”.

Any idea?


[VBA]
Range(“a1”).value=application.worksheetfunction.vlookup(“d”, columns(“C:E”),3,false).value
[/VBA]


Thanks

[Bob Phillips]

Are you sure the value is in the target table? Try using just

Application.VLookup