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