Need help with two cell accumulator
 

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


--
dlashley
------------------------------------------------------------------------
dlashley's Profile: http://www.excelforum.com/member.php...o&userid=34369
View this thread: http://www.excelforum.com/showthread...hreadid=541466

Need help with two cell accumulator
 

You are confusing macros and formulas - the formula in G13 is a
circular reference as it adds it's own value to itself. The sub itself
is fine from a coding point of view