Have a look in HELP index for SUBTOTAL

--
Don Guillett
SalesAid Software

"gmet" wrote in message
...
I have a column of data that I filter according to user
input. I need to count the number of items in the filter.
For example, I filter column A for "XYZ" and discover
that there are 11 items in the filter. I can count them
visually but I need to count them programmatically.

How can I do that? If I try to run Countif(), I get an
error message.

Gmet