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

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

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