count visible cells after autofilter

  • Thread starter Thread starter Ludo
  • Start date Start date
L

Ludo

Hi,

I have a worksheet where i use Autofilter to select one item from the
list.
What i would like to obtain is that, when i select an item with the
Autofilter that i can place the number of visible rows containing data
in cell F1, so not counting the empty rows.

After selecting an other item from the Autofilter list, i would like
that the cell F1 returs the number of visible cells at that moment.

Is it possible to do this?
Any help welcome.

Regards,
Ludo
 
If you mean the number of visible rows
=SUBTOTAL(102,A:A)

Regards,
Stefi

„Ludo†ezt írta:
 
Back
Top