I have a spread sheet with a number of formulas in cells; for example:
cell A1 =SUM(B1+C1).
Sometimes it may be necessary for the user to enter a different number in
cell A1, which deletes the formula. I need some code (or something) that
will monitor cell A1, and if this cell is empty, it will replace the correct
formula back in the cell. This way, the user only has to remember that if a
cell (A1) doesn't work properly, they just delete what is in the cell, and
the formula will return. Any suggestions? Thanks
--
Howard