Ah! Well.., that's not how I'd go about the task as its intent implies.
I'd probably want to know individual totals for each value being
searched for matches, as well as a grand total for all matches found.
That requires a slightly different approach whereby I'd store results
in a dynamic array, and probably use WorksheetFunction.Counta() on the
range being searched since it'll be orders of magnitude faster than
using Match() as well as not raising any errors in the process.

HTH

--
Garry

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