 <p>You have 2 paste operations in your code. One that you know of:</p> <p>WshtCrnt.Paste</p> <p>and one that is part of this range copy statement:</p> <p>. . With WshtSht1 .Range(.Cells(1, 1), .Cells(RowSht1DataFirst - 1, ColSht1LastHdr)).Copy_ Destination:=WshtCrnt.Range("A1") . .</p> <p>By specifying a "Destination" you are requesting a copy AND paste of your range.</p>