| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count visible cells after autofilter
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count visible cells after autofilter
If you mean the number of visible rows
=SUBTOTAL(102,A:A) Regards, Stefi €˛Ludo€¯ ezt Ć*rta: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA (or Excel) crashes if Count of Visible Rows in Autofilter Range = 1 | Excel Programming | |||
| how can i choose only visible cells from a autofilter? | Excel Worksheet Functions | |||
| how can i choose only visible cells from a autofilter? | Excel Worksheet Functions | |||
| How can I get a formula to work on visible cells with autofilter? | Excel Discussion (Misc queries) | |||
| Autofilter - display column showing visible row count | Excel Discussion (Misc queries) | |||
Linear Mode
