How to display No. of records in status bar

[EckyThump]

I have a couple of spreadsheets with autofilters in various guises (checkboxes, radio buttons, drop down list etc).
most of these when apllied show "X of X Records" in the status bar.
The one I am working on now only shows "Filter Mode" in the status bar.
How can I get the number of filtered records in the status bar or in a control on the sheet?
I have looked everywhere but have come up blank!
Thanks

 

[PHV]

Something like this ?
yourFilteredRange.SpecialCells(xlCellTypeVisible).Rows.Count

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886