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