If the sum of a range increases, run 1 Macro, if decreases, run another

[brumby]

Hiya all,

As per the title, I would like VBA to run different macros if the sum range of n6:w200 increase's call Macro1, if it decreases run Macro2.

Many Thanks

 

[mole999]

put the value of the sum in a spare cell first, then on worksheet change which will start the macro, compare the sum against the stored value, use a IF or similar decision filter and use that to direct which code is called. at the end be sure to reupdate the stored value, and also code for what happens should the total not change