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