set rng = selection.CurrentRegion
if rng.row = 1 then _
set rng = rng.offset(1,0).Resize(rng.rows.count-1)
rng.Select
--
Regards,
Tom Ogilvy
"aapp81" wrote in message
...
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 doing
"currentregion" selects them as well... and i want it to start from
row2
------------------------------------------------
~~ 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