View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default what is the formula for adding a new number to the existing numbe.

Assuming that this is a line of vba code, you must keep in mind that
everytime you run through this line the results in cell A1 will be different !

Let's say that B2 contains the value of 10
and A1 contains 5

After running this code line, A1 will = 15
If it is run again BEFORE B2 changes, then A1 will = 25 and will increment
by 10 each run as long as something does not change B2

However, you may have something changing cell B2 in between incidents of
running the code. If so A1 will be increased by the value of B2 at the time
the code is run.

"jimb" wrote:

A1=A1+B2 gives inconsistant results, is there another way to do this?