Hello,

I have unsuccessfully tried Worksheetfunction.Vlookup looking for a date.
It works fine if I place a formula as ActiveCell.Formula = "=Vlookup"

Is their any trick I should be aware of when using the a date value in
Worksheetfunction.Vlookup?

bwilcox

Just make sure the formula parameters match, in type, the cell values. For
example, if the cells are truly dates (not text that looks like dates) then
be sure to use a date value for the lookup; i.e this should work
WorksheetFunction.Vlookup(DateValue("1/1/2005"),LookupRange,2,False)
Where this would not
WorksheetFunction.Vlookup("1/1/2005",LookupRange,2,False)

"Robert Wilcox" wrote:

Hello,

I have unsuccessfully tried Worksheetfunction.Vlookup looking for a date.
It works fine if I place a formula as ActiveCell.Formula = "=Vlookup"

Is their any trick I should be aware of when using the a date value in
Worksheetfunction.Vlookup?

bwilcox