See Debra Dalgleish's site for info on this.

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


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 07:28:01 -0700, DougD
wrote:

I use Autofilter command a lot and many times it shows the total number of
filtered records from the total anount of records in the lower-left hand part
of screen. For instance - it will sat "33 of 90 records found". Inevitably,
this stops working and this area just sates "Filter Mode" without the
previous info. I have been unable to find any rhyme or reason what I did to
stop the valubale info of how many records were found.