Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Suppose I have a 60 x 9 cell range that is initially empty.
Users will be able to fill data into each row. Is there a quick and efficient method to count how many rows contain data?? (A row is considered to contain data if any one more cells of the 9 columns of that row contain any type of data) IMPORTANT: I would like to be able to retrieve the count of used rows every time data is added or deleted from the 60x9 cell range. Also, I'm looking for a FAST way to count the number of rows that contain data. I already know that I can scan each row one at a time and get the count, but I'm interested in a faster technique since my table will likely be much bigger than 60 rows. Isn't there a faster scheme that handles the "Worksheet_Change" event to retrieve the count of used rows in a range?? I'd appreciate any innovative ideas here. Thank you! Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenate many rows quickly | Excel Worksheet Functions | |||
How to quickly paste almost same formula to set rows? | Excel Discussion (Misc queries) | |||
How to quickly insert a blank row every 5 rows? | Excel Discussion (Misc queries) | |||
count based on two fields - need quickly | Excel Worksheet Functions | |||
select alternate rows - quickly | Excel Programming |