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