Range("A8").CurrentRegion.Select
should work regardless

or if you only want to L and that won't change

Range("A8").currentRegion.Resize(,12).Select
will select the populated rows out to column L


or if you have cells in column A selected
Selection.End(xltoright).Select

or to ensure to L and only out to L

Select.resize(,12).Select

--
Regards,
Tom Ogilvy


abxy wrote in message
...
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/