If the current cell was A1 then using this formula would
highlight/select the range A1:J1.


Selection.Resize(Selection.Rows.Count, Selection.Columns.Count +
9).Select

hope this points you in the right direction

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=399043