AutoFilter - How to determine number of records found

J

JRB

I would like to display a message containing the number of records found by
an autofilter run from vba

How do I count the records ?

Regards & TIA
 
G

Guest

Use ...
MsgBox Application.WorksheetFunction.Subtotal(3, Range("A:A"))
where A:A is the range you want to count.
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
G

Guest

There's no 'Was this post helpful to you? YES NO' at the bottom of the post?
Son of a gun!
Thanks for the info.
 

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

Autofilter question 5
How to "Capture" Records Found Number During AutoFilter 2
Excel VBA filtering 2
count visible cells after autofilter 1
How to get the count of filtered rows after applying autofilter? 2
VBA: How can I use a string variable as autofilter criteria? 4
autofilter 2
retrieving "Records Found" 2

Top