Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2006

Tip: Looking for answers? Try searching our database.

Need help with two cell accumulator

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dlashley - 12 May 2006 09:41 GMT
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

Signature

dlashley

aidan.heritage@virgin.net - 12 May 2006 11:02 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.