What is the syntax to copy one sheet to another?

Sheets(“<old sheet name>”).Range(“<range you want to copy>”).Copy Destination := Sheets(“<new sheet name>”).Range(“<same range>”)
'example
Sheets(“resultsMay”).Range(“A1:Z100”).Copy Destination := Sheets(“resultsJune”).Range(“A1:Z100”)
Advertisements

What is the syntax to copy a cell’s value into another cell?

Range(“<cell reference>”) = Range(“<cell containing original value>”)
‘examples
Range(“A2”) = Range(“D2”) ‘copies value of D2 to cell A2
Worksheets("Sheet1").Range("A2") = Worksheets("Sheet2").Range("D2") ‘copies value of D2 on Sheet2, to A2 on Sheet 1