Auto Filter Status Bar

[bkbrueggemann]

How do I get the status bar in Auto Filter to show the number of records
returned (e.g., 122 of 335 records found)? Right now, it only changes from
"ready" to "filter mode."

[Gord Dibben]

Check out the info on this at Debra Dalgleish's site.

http://www.contextures.on.ca/xlautofilter02.html#Count


Gord Dibben Excel MVP

On Mon, 5 Dec 2005 10:21:02 -0800, "bkbrueggemann"
<[email protected]> wrote:

>How do I get the status bar in Auto Filter to show the number of records
>returned (e.g., 122 of 335 records found)? Right now, it only changes from
>"ready" to "filter mode."

[bkbrueggemann]

Thank you! This is exactly what I needed.

"Gord Dibben" wrote:

> Check out the info on this at Debra Dalgleish's site.
>
> http://www.contextures.on.ca/xlautofilter02.html#Count
>
>
> Gord Dibben Excel MVP
>
> On Mon, 5 Dec 2005 10:21:02 -0800, "bkbrueggemann"
> <[email protected]> wrote:
>
> >How do I get the status bar in Auto Filter to show the number of records
> >returned (e.g., 122 of 335 records found)? Right now, it only changes from
> >"ready" to "filter mode."
>