Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advanced Filter - extracting unique records | Excel Worksheet Functions | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
Results of Advanced Filter to Array | Excel Programming | |||
Advanced Filter/ Extracting Data | Excel Discussion (Misc queries) | |||
Advanced Filter/Extracting Data | Excel Discussion (Misc queries) |