Status Bar

[Bill Oertell]

A coworker had a spreadsheet that showed on the status bar the number of matches
in an autofilter. IOW, when she selected an autofilter item, the status bar
showed how many items there were. I'm pretty sure that's not a native Excel
feature but a macro. If it were a macro, what would it look like? If it is a
native Excel feature, how does one activate it?

 

[Rob van Gelder]

I'm running XL2000.
The status bar reads "1 of 8 records found" for my sample list when
autofiltered.

 

[David McRitchie]

I have XL 2000 also, but all I see for Auto Filter is "Filter Mode" on the statusbar

 

[Nick Cranham]

I'm with Rob, "2 of 5 records found".
No way I can find to hide, change affect.
Office2000.

NickHK

 

[Gord Dibben]

Bill

From a post by Debra Dalgleish on this subject...........

When your list has many formulas, the Status Bar may show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.

The following MSKB article has some information:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?id=213886

And a couple of workarounds:
http://www.contextures.com/xlautofilter02.html#Count


Gord Dibben Excel MVP

 

[Tom Ogilvy]

I believe if there are fomulas in the filtered range, you get Filter mode
and if all constants, then you get the count. It could be more specific
than that (it might be formulas in the column(s) with the active filter(s)),
but there is a KB article that talks about this. This was different from
behavior in xl95 and earlier where I believe you always got the count.

 

[Holger Ostlender]

Hi,

you can activate your status bar under the options ind the "extra"-menu.

Per VBA you could use Application.StatusBar for changing the status bar

Holger

www.or-its.de