View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Krogh Frank Krogh is offline
external usenet poster
 
Posts: 8
Default How to count rows in a user-defined AutoFilter or AdvancedFilter is active?

How do I count rows in a user-defined Auto-filter on the following columns?

ID Age Sex
123 54 male
321 76 female
432 33 male

Can I apply the same method on a predefined filter criteria (using the
AdvancedFilter function)?

Thanks for any suggestions.


Frank Krogh