Re: Select last cell before blank, then offset

**bryant_16** · 03-19-2009, 01:29 AM

i'm facing a problem right now. i'm doing a for loop for the columns but as the table is dynamic, i cant do a Range(C13:C14) as C14 will be changing with every new inputs.

therefore, how do i return the last cell so that i can put in the cell number in my sub() ?

Thanks for your time.

**royUK** · 03-19-2009, 03:21 AM

You might get bettr help if you post the fullcode

Please Login or Register  to view this content.

**DonkeyOte** · 03-19-2009, 05:16 AM

I agree with Roy that it's not particularly easily to understand what it is you're doing exactly but I would say that given you're running 2007 it may be better to use Rows.Count rather than 65536, eg:

Please Login or Register  to view this content.

Rows.Count is generally regarded as optimal now I think given the difference in default Rows between pre and post 2007 versions.

**bryant_16** · 03-19-2009, 05:32 AM

Erm, sorry, i'm new to vb. Can it return a cell number?

**royUK** · 03-19-2009, 06:07 AM

What do you mean by Cell Number?

**bryant_16** · 03-19-2009, 06:29 AM

meaning er like, i got a For each cell in Range(C13:C23)

but this C23 is not constant, meaning it is dynamic and there will be new entry coming in which means next time will be C13:C24 and so on.

How do I check for this and put it into my For each statements?

**bryant_16** · 03-19-2009, 07:51 AM

hey guys, this is what i have:

For i = 1 To ddd.count
UserForm1.TextBox1.Text = ddd.Item(i)
Next i
UserForm1.Show

Basically what I want to do is to append the items in ddd (collections) to the TextBox. How do you go about doing it?