View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robinsonie@hotmail.com is offline
external usenet poster
 
Posts: 4
Default Accumulatar Cell

You could keep 2 public variables, say A1Ref and B1Ref, and on the
worksheet change event have something like this

if range("A1").value < A1Ref AND range("B1").value < B1Ref then
range("D1").value = range("A1").value + range("B1").value
A1Ref = range("A1").value
B1Ref = Range("B1").value
End If

Although the problem with this is if A1 changes twice before B1 changes
or vice versa, would this happen?