Maybe
Application.CountA(Columns("C:C").SpecialCells(xlC ellTypeVisible))
--
HTH
Bob Phillips
"sho" wrote in message
...
I'd like to both:
List each of the occurences in an autofiltered list
Count how many of each of the occurences in an autofiltered list
|