Thanks, good ideas and discussion there. My problem isn't exactly what is
described. My problem is when the filter is applied the status bar still
shows "Ready". Something is whacky on the data on this sheet. Can't
figure out what it is.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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?