This is driving me nuts! It is mainly due to the fact that I am a new user to this. I have a workbook that contains several worksheets. I have the correct formulas in place, and I have created a Macro (Called Test_1) that seems to work so far. How ever I would like the Macro to run when cells G12 through G122, and H12 through H122 (these are on a work sheet named Inv.) have a value greater than 0. Or are changed from their current value. I have tried several times to get the VB code correct, but I just keep missing something. Any suggestions?