View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yves Janssens Yves Janssens is offline
external usenet poster
 
Posts: 4
Default Worksheetfunction MATCH

Hi,

When I try the following I always get Run-time Error '1004': Unable to get
the Match property of the WorksheetFunction class

Workbooks.Open Filename:=filenaam, ReadOnly:=True
myVar = Application.WorksheetFunction.Match(9,
Worksheets(1).Range("A1:A10"), 0)
MsgBox myVar


What is the fault, I don't really see it.


Thanks a lot in advance,

Yves