Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count within a range
I think this is simple, but I am stuck. I have a named range with 6 rows
and 4 columns. Not all cells in this range are occupied. I want to count the number of entries on the 5th row of this range, for instance. There are many named ranges I want to use the same code on, so I do not want to just hard reference that section of that range. I am wanting to use the 'application.counta' function vs. a loop. Thanks, Mike Allen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count within a range
application.CountA(Range("MyRange").Rows(5))
-- Regards, Tom Ogilvy "mike allen" wrote in message ... I think this is simple, but I am stuck. I have a named range with 6 rows and 4 columns. Not all cells in this range are occupied. I want to count the number of entries on the 5th row of this range, for instance. There are many named ranges I want to use the same code on, so I do not want to just hard reference that section of that range. I am wanting to use the 'application.counta' function vs. a loop. Thanks, Mike Allen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Vaules in a range that appear in another range | Excel Worksheet Functions | |||
Count within a Range Q | Excel Worksheet Functions | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |