Auto Filter Status Bar

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."

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"
<bkbrueggemann@discussions.microsoft.com> 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."

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"
> <bkbrueggemann@discussions.microsoft.com> 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."
>