Filtered Count
Hi,
I have an always changing list. This list is filtered to only show what I want, how can I count the filtered list. I've done a count of the range but it still counts everything, I only want what is still visible. Currently I have the list being copied to another sheet, counted and the count being pasted back to the list sheet but this is time consuming. Thanks Dean |
Filtered Count
Dean,
The following code counts the rows count of visible filtered range. MsgBox ActiveSheet.AutoFilter.Range.Columns( _ 1).SpecialCells(xlCellTypeVisible).Cells.Count - 1 -- Regards, Colo http://www.puremis.net/excel/ "Dean" wrote in message oups.com... Hi, I have an always changing list. This list is filtered to only show what I want, how can I count the filtered list. I've done a count of the range but it still counts everything, I only want what is still visible. Currently I have the list being copied to another sheet, counted and the count being pasted back to the list sheet but this is time consuming. Thanks Dean |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com