Hi
this is probably our second parameter. Is this a defined name?.
the following should work:
ndx = Application.WorksheetFunction.Match(aDate, Range("A1:A100"))
if aDate exists within your range

--
Regards
Frank Kabel
Frankfurt, Germany

Ken wrote:
I want to use the Excel Worksheet Function Match to find
an entry in a range. When attempting to execute, I get
error code 1004. Unable to get the Match Property of the
Worksheet function class.

ndx = Application.WorksheetFunction.Match(aDate, "AMGN!
Date")

What is not available?