Sunday, April 21, 2019

Another way to copy data and paste within workbook

Another way to copy data and paste within workbook

Worksheets("SUNRAW").Range("A1:C10000").Copy
    Worksheets("SUNPIV").Range("A26").PasteSpecial Paste:=xlPasteValues

Worksheets("SUNRAW").Range("D1:D10000").Copy
    Worksheets("SUNPIV").Range("E26").PasteSpecial Paste:=xlPasteValues

Worksheets("SUNPIV").Range("h2:h10000").Copy
    Worksheets("SUNPIV").Range("d26").PasteSpecial Paste:=xlPasteValues

No comments:

Post a Comment