Ok, i don't know exactly what it is that i'm doing wrong (I suppose
it's becuase I don't understand .Resize fully right now, so maybe
it'd help if i stop generalizing, and explain my exact problem.

Ok, I paste data in excel(cell A8), but the length of the data
varies.
So, let's say for example, that I just pasted in my data and it's 10
rows long(si rught now, cells A8:A18 would be selectied). what I need
is the equivalant of holding shift and press the right arrow until
the
selection reaches the L column...but without referring to particular
cells, becuase the data length could be A8:18 this time, and A8:A76
the next.


---
Message posted from http://www.ExcelForum.com/

Hi
try
....
Dim rng as range
set rng = Range("A8").Resize(rows_count,1)
....

rng will be a range starting in A8, with rows_count rows and 1 column.

Frank