D
dlashley
Hello,
I am trying to do a two cell accumulator and I am having trouble
getting it to work. It keeps coming back with an circular reference
error and it's not adding up when I put in a value. I would like to
place a number in say cell C13 and have it add to cell G13. G13 is
where I want to keep my running total. I entered a macro in cell G13
that states (=C13+G13) and also I have entered a vba script that
states:
( Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Column = 1 Then
Target(1, 2).Value = Target(1, 2).Value + Target.Value
End If
End Sub)
Can someone please help me out with this I am at a total loss! Thanks
in advance
Dawn
I am trying to do a two cell accumulator and I am having trouble
getting it to work. It keeps coming back with an circular reference
error and it's not adding up when I put in a value. I would like to
place a number in say cell C13 and have it add to cell G13. G13 is
where I want to keep my running total. I entered a macro in cell G13
that states (=C13+G13) and also I have entered a vba script that
states:
( Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Column = 1 Then
Target(1, 2).Value = Target(1, 2).Value + Target.Value
End If
End Sub)
Can someone please help me out with this I am at a total loss! Thanks
in advance
Dawn