|
WorksheetFunction.Match applied on an Array
Charles,
"Worksheetfunction.Match is faster than using Application.Match" Does that apply to the use of all worksheet functions in VBA? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Charles Williams" wrote in message Hi Werner, If you use Worksheetfunction.Match with exact match an error is raised if there is no match, so you need to error trap it with On Error. If you use Application.Match no error is raised but an error value is returned instead Note that using Worksheetfunction.Match is faster than using Application.Match regards Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm |
WorksheetFunction.Match applied on an Array
Jim,
Well I have not tested it so I dont know ... Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm "Jim Cone" wrote in message ... Charles, "Worksheetfunction.Match is faster than using Application.Match" Does that apply to the use of all worksheet functions in VBA? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Charles Williams" wrote in message Hi Werner, If you use Worksheetfunction.Match with exact match an error is raised if there is no match, so you need to error trap it with On Error. If you use Application.Match no error is raised but an error value is returned instead Note that using Worksheetfunction.Match is faster than using Application.Match regards Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm |
WorksheetFunction.Match applied on an Array
Charles, I was afraid that would be the answer. I certainly don't want to spend the time to do the tests.<g Thanks, Jim Cone "Charles Williams" wrote in message Jim, Well I have not tested it so I dont know ... Charles "Jim Cone" wrote in message Charles, "Worksheetfunction.Match is faster than using Application.Match" Does that apply to the use of all worksheet functions in VBA? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Charles Williams" wrote in message Hi Werner, If you use Worksheetfunction.Match with exact match an error is raised if there is no match, so you need to error trap it with On Error. If you use Application.Match no error is raised but an error value is returned instead Note that using Worksheetfunction.Match is faster than using Application.Match regards Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm |
| All times are GMT +1. The time now is 09:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com