Add two columns together back to first and deleting data on second

[MichelGagnon]

Hi!

I am trying to add the numbers in column C (starting at C3 to C2000) with the numbers in column E and have the results go back to C.
Ex: C3=C3+E3
Then C3=0

I have found this code online that I have adapted, but it doesn’t seem to work.
Nothing happens except that it tells me that I have a circular reference.

Sub numSum()
For i = 3 To 2000
Sheet1.Range("C" & i).Value = Sheet1.Range("C" & i).Value + Sheet1.Range("E" & i).Value
Sheet1.Range("E" & i).Value = 0
Next i
End Sub

 

[MichelGagnon]

Oups! I ment E3=0 (not C3=0)

 

[MichelGagnon]

I found my problem!!

Sub numSum()
For i = 3 To lRow
Worksheets("Inventory_list").Range("C" &i).Value = Worksheets("Inventory_list").Range("C" &i).Value + Worksheets("Inventory_list").Range("E" &i).Value
Next i
End Sub