Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional counting of autolist cells/rows
Having a bit of a problem with autolist/count function Have written a function for counting visible cells for an autolist. Was hoping that the following code would work: Rng is the range for the autolist column in question: rng.SpecialCells(xlCellTypeVisible).count - should count the visible cells. this counts all rows not just the visible ones... would like to use countif to count conditionally to like: worksheetfunction.CountIf(rng.SpecialCells(xlCellT ypeVisible),3) - should count visible cells with he value 3 in he appropriate column... Probably me being stupid but why doesn't it work, please help!! /Johan Litsén -- johli ------------------------------------------------------------------------ johli's Profile: http://www.excelforum.com/member.php...o&userid=27388 View this thread: http://www.excelforum.com/showthread...hreadid=470203 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
conditional counting | Excel Discussion (Misc queries) | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |