retrieving "Records Found"
 

When using VBA to access the Autofilter method, is there a way to access the
# of Records found?

retrieving "Records Found"
 

Not really (since there is no guarantee it will be in the status bar), but
it is easy to get

dim rng as Range
set rng = Activesheet.autofilter.Range.columns(1).Cells

set rng = rng.specialcells(xlvisible)

msgbox "Records found: " & rng.count - 1

you subtract 1, because rng would include the header row.

--
Regards,
Tom Ogilvy




"asmenut" wrote in message
...
When using VBA to access the Autofilter method, is there a way to access
the
# of Records found?

retrieving "Records Found"
 

THANK YOU.

I knew there had to be a way to get the information I needed. I just needed
to submit the question the right way.

You guys are the best. Microsoft chose their MVP's very well

"Tom Ogilvy" wrote:

Not really (since there is no guarantee it will be in the status bar), but
it is easy to get

dim rng as Range
set rng = Activesheet.autofilter.Range.columns(1).Cells

set rng = rng.specialcells(xlvisible)

msgbox "Records found: " & rng.count - 1

you subtract 1, because rng would include the header row.

--
Regards,
Tom Ogilvy




"asmenut" wrote in message
...
When using VBA to access the Autofilter method, is there a way to access
the
# of Records found?