My recorded macro gone wrong?

Firstly may I say thanks to any members willing to take a look at my problem,
which is, I have recorded a macro to copy the content's from a range of cells
and paste them into a new sheet, then return to the original cell (D7) which is
a merged cell (D7:F7) , end of record.

The problem is, it has copied the content's fine but it has also removed the contents
from the selected cell (D7), therefor there must be something in the code telling it
to delete (D7).
This macro is a lot longer then this so I have only pasted the code below which I think
is relevant.
Many Thanks to anybody that can point me in the right direction.
CrashMatRob.

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

waiting for edit per mod request

Try:

Please Login or Register  to view this content.