JayDax

If you are not seeing a count of records on the status bar see Debra
Dalgleish's site for reasons and workarounds.

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


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 13:42:15 -0700, JayDax
wrote:

I have two Excel spreadsheets. In one the results of applying a filter are
displayed in the status bar - eg. '24 of 144 records found'. In the other I
get just 'Filter mode'.
I've examined the option settings - they appear identical. There are no
macros attached to the sheets either. The '24 of 144 records found' type of
message is very useful. How do I make all my spreadsheets produce it on
filtering?