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