View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andrew andrew is offline
external usenet poster
 
Posts: 1
Default Count of results in AutoFilter

Hello all,

I have an autofilter running through a macro - but I would
like to retrieve the number of rows that met the filter
criteria.

Is there a .count property (or something similar) on the
AutoFilter object? If not, is there a countif(visible)
formula I could use directly in the worksheet?

Thanks!!!!