Hello,

I have a problem in VBA that i can't get my head around...

I have two rows of data.. One on row 17 and one on row 31 of the same
tab. I need VBA to copy the row (both 17 & 31) and insert a new copied
row underneath... The probem is that when i run it again, because of
the insert from row 17 it needs to copy row 32 but it re copys 31,
which eventually becomes a header...?

How do i get it to effectivly follow row 31 and grow as the data
does..

Thanks alot

Mike


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