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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter problem 7
How to set range to autofiltered visible cells? 7
How to get the count of filtered rows after applying autofilter? 2
Select rows with visible data 0
SELECTING AN ITEM FROM AUTO FILTER ! 2
AutoFilter & Selecting First Visible Cell 2
after autofilter/delete rows left not visible 1
select all (including hidden) rows in autofilter region 2

Back
Top