Drrott1


set a variable with the row number that has the 1st occurance of yo
find text
eg rStart = 12

find last row that matches text

rLast = 20



use this code to copy & paste rows

Rows(rstart & ":" & rlast).Copy

rows(30).paste
or
sheets("sheet2").rows(1).past

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=27048