# what is the formula for adding a new number to the existing numbe.

1. ## what is the formula for adding a new number to the existing numbe.

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

2. ## Re: what is the formula for adding a new number to the existing numbe.

Inconsistant results? I find that hard to believe! This type of statement is
used heavily in VBA to self-increment a variable and has never failed me-
unless your code is not right!

--
|
+--Thief_
|

"jimb" <jimb@discussions.microsoft.com> wrote in message
news:5FC2C68B-4657-4EA0-AE24-B11B53136864@microsoft.com...
> A1=A1+B2 gives inconsistant results, is there another way to do this?

3. ## RE: 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?

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1