Assuming you were sending a value from Cell A1 on Sheet 1 to Cell A1 on Sheet2, here are a few:
or (this one transfers formulas as well)![]()
Sheets("Sheet2").Range("A1").Value = Sheets("Sheet1").Range("A1").Value
or![]()
Sheets("Sheet1").Range("A1").Copy Destination:=Sheets("Sheet2").Range("A1")
![]()
Sheets("Sheet1").Range("A1").Copy Sheets("Sheet2").Range("A1").PasteSpecial
Bookmarks