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?

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bill Oertell" wrote in message
...
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?

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

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

"Bill Oertell" wrote ...
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?

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

NickHK

"David McRitchie" wrote in message
...
I have XL 2000 also, but all I see for Auto Filter is "Filter Mode" on
the statusbar

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

"Bill Oertell" wrote ...
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?

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.

--
regards,
Tom Ogilvy

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

NickHK

"David McRitchie" wrote in message
...
I have XL 2000 also, but all I see for Auto Filter is "Filter Mode" on
the statusbar

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

"Bill Oertell" wrote ...
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?

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

On Thu, 19 Feb 2004 18:50:25 -0800, "Bill Oertell"
wrote:

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?

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