Excel 2003 Macro to re-calculate until...

[Dan]

How can I write a macro that will re-calculate an active worksheet until a
certain cell = zero? I only have experience (limited) with keystroke macros,
so any and all details will help.

Thanks

 

[JE McGimpsey]

You don't give any details, so it's hard to say what the best macro
technique would be.

However, if you have iterative calculations, using Goal Seek or Solver
would seem to be better alternatives...

 

[Dan]

All I want to do is calculate the entire worksheet, same as using the F9 key,
until a certain cell, let's say P1 is equal to zero.

Thanks

 

[Marcelo]

OK, P1 should receive datas from another one, the goal seek is the best way
to solve it



"Dan" escreveu:

 

[Dan]

Goal seek does not work in this case. P1 is the sum of all cells in column O.
The cells in column O are numbers based on true/false tests from other cells.
Many cells must be recalculated to give the result in cell P1.

Thanks