AutoFilter - How to determine number of records found

[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

 

[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.

 

[JRB]

Exactly what I needed - Muchly Grateful

BTW - No 'Yes' at bottom of the post

 

[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.