How do I stop Filter Mode from appearing in the status bar
 

When I filter data using Autofilter the number of rows filtered from the
total does not appear in the Status Bar. "Filter Mode" appears in the Status
Bar instantaneously. How do you stop this?

Thanks!
CDH

Take a look at Debra Dalgleish's site for an explanation and a couple of
workarounds.

http://www.contextures.com/xlautofilter02.html#Count



Seedy H wrote:

When I filter data using Autofilter the number of rows filtered from the
total does not appear in the Status Bar. "Filter Mode" appears in the Status
Bar instantaneously. How do you stop this?

Thanks!
CDH

--

Dave Peterson