PDA

View Full Version : Unable to get the Vlookup property of the WorksheetFunction class



uktous
07-31-2012, 02:35 AM
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?



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



Thanks

Bob Phillips
07-31-2012, 02:49 AM
Are you sure the value is in the target table? Try using just

Application.VLookup