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
--
Dan

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...


In article ,
Dan wrote:

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

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
--
Dan


"JE McGimpsey" wrote:

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...


In article ,
Dan wrote:

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

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



"Dan" escreveu:

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
--
Dan


"JE McGimpsey" wrote:

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...


In article ,
Dan wrote:

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

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
--
Dan


"Marcelo" wrote:

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



"Dan" escreveu:

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
--
Dan


"JE McGimpsey" wrote:

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...


In article ,
Dan wrote:

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