Check out Debra Dalgleish's site for info on this.

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


Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 14:19:23 -0500, "Kent McPherson"
wrote:

I have a spreadsheet where I enable auto filtering. When I select a
particular filter category, normally in the status bar, it says xx of yy
records selected. But this is gone in my worksheet. If I copy the entire
data set and paste it into a new worksheet in the same workbook and do the
filter, it works! The status bar is turned on. Any ideas why it doesn't
show up in this particular worksheet?