Dick Kusleika wrote:
*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.
*

yeah, i thought about doing that but i have headings in A1:T1 and doin
"currentregion" selects them as well... and i want it to start fro
row

-----------------------------------------------
~~ 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