Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Code
Hey guys I have a list of values in range Column A:A.
There is a value in cell A7, then the next value in the range is in cell A10, then A13. As you can see there is value in every 3 cells. There maybe 700 values but they span in a range from approximately A7:A2100. I usually use the count or counta function in my loop codes to specify the end of the range, but in this case the count function will not work because there are many blank cells in the range. How do I look for the last value in column A:A and return that cell number? For instance, the last value in Column A:A is 1929. I need the code to return 1929. Thank you Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code for counting the order cells are filled | Excel Discussion (Misc queries) | |||
Code for counting number of word strings? | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting entries by color code | Excel Discussion (Misc queries) | |||
Counting names thru code | Excel Programming |