Hi,

Im pretty new to excel macros as well, and Im not sure I understoo
exactly what you need, but you could try with

Range(Selection, Selection.End(xlDown)).Select

Its the same as using CTRL+SHIFT+DOWNARROW - which means if you have
list of unknown length, it will just select from where you are, to th
last filled row going down.

The only thing is that your active cell need to be in the filled colum

--
lonfnic
-----------------------------------------------------------------------
lonfnico's Profile: http://www.excelforum.com/member.php...fo&userid=3339
View this thread: http://www.excelforum.com/showthread.php?threadid=53207