Thanks...

I cant quite get this to work because im adding it to script i already
have and cant quite tie it together...

Whole cenario is i have a tab with 2 rows of data on... one on row *10*
and one on row *20* for instance. I need these data sources to grow....
so the macro will copy row *10*, insert and paste the data below in a
new row. Same for row *20*, the problem occurs when on running it a
second time it copys row *20* again, when because of the insert above
by row 10 it effectivly needs to look for row *21* copy insert and
paste....???

Thanks Again...


--
Mikey2005
------------------------------------------------------------------------
Mikey2005's Profile: http://www.excelforum.com/member.php...o&userid=31316
View this thread: http://www.excelforum.com/showthread...hreadid=510015