Hi, I need a macro to run a piece of code which is already written. I have a cell IV1 a with a sum formula. When ever the total in IV1 changes then i want macro to run. I dont even want to touch cell IV1. I tried Worksheet-Change event, but it works only when i access the cell IV1 , It will not work when value is changed in IV1 when i not access that cell. Kindly help me.
Regards,
Srinayana
Regards,
Srinayana