A1=A1+B2 gives inconsistant results, is there another way to do this?
A1=A1+B2 gives inconsistant results, is there another way to do this?
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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks