LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.WorksheetFunction.Match TK[_4_] Excel Programming 2 September 6th 05 09:46 PM
Excel2000 VBA: A problem with worksheetfunction MATCH Arvi Laanemets Excel Programming 7 June 16th 05 02:01 PM
Syntax for WorksheetFunction Match Hardy[_3_] Excel Programming 1 June 4th 04 11:33 AM
worksheetfunction.match David Robinson[_3_] Excel Programming 4 November 15th 03 06:35 PM
Worksheetfunction MATCH Yves Janssens Excel Programming 2 October 6th 03 03:25 PM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"