Filter - # of Record found

[Chuck Moran]

I'm using Excel 2010.
When using Filters the "# of records found" is shown on the Status Bar. ie: 5 of 82 records found.

Can someone help me get the # (5 in the example) be obtained to use on a "Form"?

Any help is appreciated.
Thanks!
Chuck

 

[Gerald Higgins]

There are probably better ways of doing this, but you could try using the SUBTOTAL function, for example

=subtotal(2,a2:a82)

will count how many items in your target range are visible, and will change if you filter it.
I'm assuming you have a header line on row 1.
The 2 argument specifies COUNT, there are other options.
If you put this formula in a cell, you might be able to bring the result onto a form.

You can probably also do the whole lot through VBA but I'm not an expert on that I'm afraid.

 

[Chuck Moran]

Thanks, Gerald!
I'll try anything.
(Obviously, will learn something.)

 

[Chuck Moran]

Greg,
It worked better than I could have imagined.
Thanks again!