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