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