Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Length of series
How do you find the length of a data series? I have a column with data.
Starting at a particular point in that column how do you find the last cell that contains any data? Now I have code that does that but I think there is a function that odes it for you, I just cannot figure out the name of it. My code looks like: Do Until IsEmpty(rng(1).Offset(i, 0)) = True i = i + 1 Loop |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Length of series
Sorry already asked this question. Please disregard!
"Arne Hegefors" skrev: How do you find the length of a data series? I have a column with data. Starting at a particular point in that column how do you find the last cell that contains any data? Now I have code that does that but I think there is a function that odes it for you, I just cannot figure out the name of it. My code looks like: Do Until IsEmpty(rng(1).Offset(i, 0)) = True i = i + 1 Loop |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Length of series
MsgBox (ActiveCell.End(xlDown).Row - ActiveCell.Row)
lg Robin Arne Hegefors schrieb: How do you find the length of a data series? I have a column with data. Starting at a particular point in that column how do you find the last cell that contains any data? Now I have code that does that but I think there is a function that odes it for you, I just cannot figure out the name of it. My code looks like: Do Until IsEmpty(rng(1).Offset(i, 0)) = True i = i + 1 Loop |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose random length series of cells | Excel Worksheet Functions | |||
Series with noncontiguous unequal length data? | Charts and Charting in Excel | |||
Variable series length/range | Charts and Charting in Excel | |||
remove last character in a series of different length part #'s | Excel Discussion (Misc queries) | |||
Plotting different length series in a chart | Charts and Charting in Excel |