How do I force Excel to show filter totals in the Status bar?

G

Guest

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
 
D

Don Guillett

try incorporating this idea

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When in filter mode status bar doesn't show range of cells filted 1
How do I get the filter mode to show the good row count? 2
Excel status bar: How did I get 65533 records. 1
How to hide Sheet tab Bar & status Bar for a excel file 3
How do I change the colour of the 'filter arrows' 5
formula results in the status bar 3
Auto Filter Summary in Status Bar 1
Why doesn do I show connection status in the Status Bar? 3

Top