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
Advertisements