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