Range selection
 

I'm trying to select a row of data, and am having trouble. I have
search that finds the row I want (it will change depending on th
data). Now I want it to select the first 15 cells of that row so I ca
copy it to another sheet. Example, Row 20 has the data I want, and
want it to select A20-O15. This is what I have tried so far:

Range(ActiveCell,Offset(0,15).Select

This is one example and I know it isn't right, but it gives the idea o
what I'm trying to do

--
kola556
-----------------------------------------------------------------------
kola5567's Profile: http://www.excelforum.com/member.php...fo&userid=2461
View this thread: http://www.excelforum.com/showthread.php?threadid=39904

Range selection
 

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