View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default WorksheetFunction.Match applied on an Array

Werner,

I dont know why worksheetfunction was introduced: AFAIK Microsoft have never
said why.

Speed: worksheetfunction has been somewhat faster in all the tests I have
done, but of course I have not tested every possible scenario.

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

"Werner Rohrmoser" wrote in message
...
Charles,

I've found the list.
But what is the difference between Application.Match and
Application.WorksheetFunction.Match?
Or is it for downward compability, "WorksheetFunction" was introduced
some relaeses ago, I guess.

There are contrary statements about speed in this thread, does that
mean it depends on
the situation?

Regards
Werner