+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    jimb
    Guest

    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. #2
    Thief_
    Guest

    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" <[email protected]> wrote in message
    news:[email protected]...
    > A1=A1+B2 gives inconsistant results, is there another way to do this?




  3. #3
    gocush
    Guest

    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?


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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