View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sirbob@penguinking.com is offline
external usenet poster
 
Posts: 1
Default Extracting results of Advanced Filter.

Heya, folks.

When an Advanced Filter is run, the following text appears in the
Excel status bar:

"X of Y records found"

.... where X is the number of records that matched the filter criteria,
and Y is the total number of records in the filtered range.

Is there any way to extract these values programmatically? I may be
blind, but I don't see it anywhere in the relevant documentation.
I've been able to do it by capturing the status bar text and parsing
it to extract the numbers, but I'm hoping there's a more elegant way
to go about it.

Thanks,

- David Prokopetz.