Correction...

and probably use WorksheetFunction.Counta() on the range being
searched

...should read

and probably use WorksheetFunction.CountIf() on the range being
searched

Also, now that it's clear this function is being used in worksheet
formulas, I recant the idea of getting individual match criteria
totals!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion