Thread: Using WorksheetFunctions in Excel Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken[_18_] Ken[_18_] is offline
external usenet poster
  
Posts: 45
Default Using WorksheetFunctions in Excel Macros
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?
Reply With QuoteReply With Quote