View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2530_] Rick Rothstein \(MVP - VB\)[_2530_] is offline
external usenet poster
 
Posts: 1
Default Different Results running the same macro??

Sure, why not? Check out the "inflected forms" at this authoritative site...

http://www.merriam-webster.com/dictionary/outputted

Rick


"JLGWhiz" wrote in message
...
Outputted??

"Rick Rothstein (MVP - VB)" wrote:

I can think of a lot of ways to write a macro to do that. Off the top of
my
head... if the macro adds a constant to a cell reference up to some
maximum
summation value and then outputs a value based on that cell reference's
value; then, until that maximum summation is reached, a different result
will be outputted, after the maximum summation is reached, the same
repeated
value will be outputted (since the maximum summation has been reached and
doesn't change any more).

Rick


"Laurie" wrote in message
...
I am puzzled why each time when the same macro is running, there is a
different result, while after a few tims of running the macro, the
result
stays the same thereafter.

There are two possible reasons I can think of:
1. The macro has a "Calculate" statement;
2. There is another workbook open.

I am not sure if any of the above two items is the reason of different
results by running the same macro multiple times.

Thank you anyone in advance who can give me some clue here!!

Laurie