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?