I've never had that
error message with Application.Match.

I didn't talk about any particular error message. I said I have not pursued
whether it was still a problem in later versions of Excel. So I am not
following your question, but in any event, I am not sure there is any need
to ask one.

--
Regards,
Tom Ogilvy


"Myrna Larson" wrote in message
...
Hi, Tom:

Are you using On Error Resume Next?

I either do that, or use a Variant variable to receive the result of
Match.
The error that I get in the latter situation is something on the order of

Unable to get the Match property of the WorksheetFunction object.

And of course using a variant doesn't help with that. I've never had that
error message with Application.Match.

On Sun, 27 Mar 2005 19:00:31 -0500, "Tom Ogilvy" wrote:

Since the problem is intermittent, it would be hard to say - added to the
fact that my personal preference is to use Application.Match and
iserror -
so not something I have pursued.