View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default 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