I have this code to add value of a cell to an existing value of the other cell:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not (Intersect(Target, Range("E3")) Is Nothing) Then
Range("F3").Value = Range("E3").Value + Range("F3").Value
End If
End Sub
But my problem is it just work in one cell, but not in a row, that is e. g. I want to add up B1
value to A1
existing value. It works OK, but i have 24 rows, that is B2
to A2
it don't work I don't want to add them combine but separably B2
to A2
and B3
to A3
this way 24 times.
Please help, it's urgent.