AutoFilter - How to determine number of records found

's Computer Specifications

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

's Computer Specifications

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

"JRB @eclipse.co.uk>" wrote:

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

's Computer Specifications

Exactly what I needed - Muchly Grateful

BTW - No 'Yes' at bottom of the post

"Gary Brown" <gary"DeleteThis2SendMeAnEmail".(E-Mail Removed)> wrote in
message news:6622C4C5-85A6-451D-8E3F-(E-Mail Removed)...
> Use ...
> MsgBox Application.WorksheetFunction.Subtotal(3, Range("A:A"))
> where A:A is the range you want to count.
> --
> HTH,
> Gary Brown
> (E-Mail Removed)
> If this post was helpful to you, please select ''YES'' at the bottom of
> the
> post.
>
>
>
> "JRB @eclipse.co.uk>" wrote:
>
>> 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
>>
>>
>>

's Computer Specifications

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.
--
Sincerely,
Gary Brown
(E-Mail Removed)

"JRB @eclipse.co.uk>" wrote:

> Exactly what I needed - Muchly Grateful
>
> BTW - No 'Yes' at bottom of the post
>
> "Gary Brown" <gary"DeleteThis2SendMeAnEmail".(E-Mail Removed)> wrote in
> message news:6622C4C5-85A6-451D-8E3F-(E-Mail Removed)...
> > Use ...
> > MsgBox Application.WorksheetFunction.Subtotal(3, Range("A:A"))
> > where A:A is the range you want to count.
> > --
> > HTH,
> > Gary Brown
> > (E-Mail Removed)
> > If this post was helpful to you, please select ''YES'' at the bottom of
> > the
> > post.
> >
> >
> >
> > "JRB @eclipse.co.uk>" wrote:
> >
> >> 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
> >>
> >>
> >>
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AutoFilter Confusion (no records found)	Bigfoot17	Microsoft Excel Programming	3	29th Apr 2009 01:32 AM
In Excel, How do I get AutoFilter to provide# of records found?	DougD	Microsoft Excel Misc	1	19th Jun 2008 07:51 PM
How to "Capture" Records Found Number During AutoFilter	=?Utf-8?B?UGFwdXR4aQ==?=	Microsoft Excel Programming	2	21st Mar 2006 02:43 AM
Autofilter number of records	=?Utf-8?B?R2luZ2Vy?=	Microsoft Excel Worksheet Functions	3	28th Sep 2005 03:23 PM
Autofilter number of records	Thore	Microsoft Excel Misc	1	16th Jun 2004 08:58 AM