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

What result? What does the macro do? If you posted some of your code I am
sure someone can tell you exactly what the problem is.

Laurie wrote:
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

--
Message posted via http://www.officekb.com

Post YOUR code

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

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

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

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

Yeah, I found out it ain't necessarily true that ain't ain't a good word! <g

"Rick Rothstein (MVP - VB)" wrote:

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