=> AutoFilter - Amount of shown lines (LineCount)

[Alexander]

AutoFilter - Amount of shown lines (LineCount)
=================================

I want to get the Amount of Lines of an AutoFilter result.
(the amount of lines shown after I made my AutoFilter choice)


How can this be done? {Excel or Excel-VBA)

I'm looking for something like:
CountAutofilterResult(Range)

Thanks for your Help
Alexander

 

[Frank Kabel]

Hi Alexander
in addition to your answer in the German newsgrou:
=SUBTOTAL(3,A1:A100)
for a VBA solution have a look at
http://www.contextures.com/xlautofilter03.html#Count

 

[Alexander]

Thanks a lot / vielen Dank