Excel adding cells dynamically (SOLVED)

Question

How can two cells be added together in Excel such that the result is retained in the second cell, while the first cell resets to 0 after the operation?

Specifically, when Cell 1 is added to Cell 2, I want Cell 2's value to equal the sum of the original values, and then Cell 1 should become 0.

Answer 1

I solved it, the code needed was

Sub AddAndResetCells()
Dim cell1 As Range
Dim cell2 As Range

' Change the addresses to your specific cells
Set cell1 = Range("A1")
Set cell2 = Range("A2")

cell2.Value = cell1.Value + cell2.Value
cell1.Value = 0
End Sub

Answer 2

Hi,

Thanks for sharing the solution here. :D