how to run a macro when a calculation equals a certin number
 

how do I run a macro when a calculation equals a certin number and another
when it equals another certin number?

how to run a macro when a calculation equals a certin number
 

You need to construct a worksheet change event macro that can monitor the
contents of the cell containing the calculation and call macros based upon
the cell's value.
--
Gary''s Student


"Kevin Jones" wrote:

how do I run a macro when a calculation equals a certin number and another
when it equals another certin number?