Hi Myrna,

Let's see if I'm understanding you right, correct me if I'm wrong.

CountA is a worksheetfunction, all the following statements work:

cnt = Application.WorksheetFunction.CountA(rng)
cnt = WorksheetFunction.CountA(rng)
cnt = Application.CountA(rng)

Because MATCH is also a worksheet function, I would assume it should
work in exactly the same way, but because of a bug in Excel 97, only
Application.MATCH syntax will work.

To state it another way, Worksheetfunction.MATCH and Application.MATCH
are really the same statement, but only the latter works.

I don't know how I would know this unless someone told me or I stumbled
onto it quite by accident.

Dave