ExcelBanter - How do I get the filter results to show up in the status bar?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get the filter results to show up in the status bar? (https://www.excelbanter.com/excel-discussion-misc-queries/46894-how-do-i-get-filter-results-show-up-status-bar.html)

Delzeit

How do I get the filter results to show up in the status bar?

When I use the autofilter function, some worksheets display the number of
records that meet the criteria out of the total records in the left side of
the status bar. On other worksheets this is not displayed. Is there an
option for turning this on and off?

Ron de Bruin

Hi Delzeit

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Delzeit" wrote in message ...
When I use the autofilter function, some worksheets display the number of
records that meet the criteria out of the total records in the left side of
the status bar. On other worksheets this is not displayed. Is there an
option for turning this on and off?

Delzeit

Thanks for the info.

"Ron de Bruin" wrote:

Hi Delzeit

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Delzeit" wrote in message ...
When I use the autofilter function, some worksheets display the number of
records that meet the criteria out of the total records in the left side of
the status bar. On other worksheets this is not displayed. Is there an
option for turning this on and off?

All times are GMT +1. The time now is 09:16 PM.