I have a large (3600 rows; 55 Columns) Excel spreadsheet acting as a
database. I use Filters extensively and I've always appreciated the ability
to see the consequenes of filtering ("143 out of 3600 items") in the Status
Bar. Now I just get "Filter Mode".

Even when this function worked, it never remained there and disappeared
after about 10 minutes or so.

How do I force it to appear and remain until some other action is carried out?

Thanks very much

John Waldie

Australia

Take a look he

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

In article ,
spider wrote:

I have a large (3600 rows; 55 Columns) Excel spreadsheet acting as a
database. I use Filters extensively and I've always appreciated the ability
to see the consequenes of filtering ("143 out of 3600 items") in the Status
Bar. Now I just get "Filter Mode".

Even when this function worked, it never remained there and disappeared
after about 10 minutes or so.

How do I force it to appear and remain until some other action is carried out?

Thanks very much

John Waldie

Australia

try incorporating this idea

Sub statusbar()
Application.statusbar = Application.Subtotal(9, [rangename])
End Sub

--
Don Guillett
SalesAid Software

"spider" wrote in message
...
I have a large (3600 rows; 55 Columns) Excel spreadsheet acting as a
database. I use Filters extensively and I've always appreciated the
ability
to see the consequenes of filtering ("143 out of 3600 items") in the
Status
Bar. Now I just get "Filter Mode".

Even when this function worked, it never remained there and disappeared
after about 10 minutes or so.

How do I force it to appear and remain until some other action is carried
out?

Thanks very much

John Waldie

Australia