View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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