Hi, I'm having trouble making the vlookup function work in VBA.
the values that are used are all dates, I don't know if that makes a
difference.
Worksheets("sheet1").range("a1").value = application.WorksheetFunction.
_
Vlookup(Range("c1"), range("a:a"), 2)
this gives me a run-time error '1004' Unable to get the vlookup
property of the Worksheet function class
so i tried this:
Worksheets("sheet1").range("a1").value =
application.Vlookup(Range("c1"), _
range("a:a"), 2)
but this gives me a #REF error.
What am I doing wrong?
Any help would be appreciated!
--
ayl322
------------------------------------------------------------------------
ayl322's Profile:
http://www.excelforum.com/member.php...fo&userid=9846
View this thread:
http://www.excelforum.com/showthread...hreadid=390609