Macro to re-calcluate and count times run
 

I'm looking for a basic macro that re-calculates the formula in a
spreadsheet until a certain condition is met (i.e. a solution found, being a
"yes" value in a particular cell) but counts the number of times it takes
before that condition is met, and then stops recalculating and returns the
result plus the number of times that the scenario had to be run before a
solution was found. The expected number of attempts will probably be less
than 20.

Any suggestions?

Thanks in advance

Mike

Macro to re-calcluate and count times run
 

Mike

I'd try something like
Do while
conditions here
count = count +1

code here
loop

msgbox count

End sub
and place this at the start of the loop
-----Original Message-----
I'm looking for a basic macro that re-calculates the
formula in a
spreadsheet until a certain condition is met (i.e. a
solution found, being a
"yes" value in a particular cell) but counts the number
of times it takes
before that condition is met, and then stops
recalculating and returns the
result plus the number of times that the scenario had to
be run before a
solution was found. The expected number of attempts will
probably be less
than 20.

Any suggestions?

Thanks in advance

Mike


.

Macro to re-calcluate and count times run
 

thanks

mike

"Peter Atherton" wrote in message
...
Mike

I'd try something like
Do while
conditions here
count = count +1

code here
loop

msgbox count

End sub
and place this at the start of the loop
-----Original Message-----
I'm looking for a basic macro that re-calculates the
formula in a
spreadsheet until a certain condition is met (i.e. a
solution found, being a
"yes" value in a particular cell) but counts the number
of times it takes
before that condition is met, and then stops
recalculating and returns the
result plus the number of times that the scenario had to
be run before a
solution was found. The expected number of attempts will
probably be less
than 20.

Any suggestions?

Thanks in advance

Mike


.