aapp81

It should select down to the last value in column A, not T. Anyway, try
this

Selection.CurrentRegion.Select

and see if that doesn't give you the proper range.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"aapp81" wrote in message
...

i have columns A2:T2 selected and then i do this:
Range(Selection, Selection.End(xlDown)).Select
but it only selects up to the last row in column T but other cols are
longer...
is there anyway to fix this so that it selects down to the longest col?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements