I have solved half the problem by using Cells(i, 2) in:
Destination:=Cells(j+1, 1))
instead of
Destination:=Range("A1"))

There is a new row inserted, but it still starts from the last colum
of the previous row.


- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27584