Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorksheetFunction.Match applied on an Array
Try Visual Basic Help and look for
List of Worksheet Functions Available to Visual Basic or you can make the object browser enumerate the WorksheetFunction regards Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm "Werner Rohrmoser" wrote in message ... Thanks to all, On Error... is the solution. Another question, where can I find functions like Application.Match? When I look into the object browser / application I can' find it. Regards Werner |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorksheetFunction.Match applied on an Array
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.WorksheetFunction.Match | Excel Programming | |||
Excel2000 VBA: A problem with worksheetfunction MATCH | Excel Programming | |||
Syntax for WorksheetFunction Match | Excel Programming | |||
worksheetfunction.match | Excel Programming | |||
Worksheetfunction MATCH | Excel Programming |