What cells did you mean when you said "..number of formulas in cells"? Are
you talking about a range of contiguous cells (like in a column or in a row
or in a rectangular area)? If yes, are the formulas in this range of cells
identical except for the cells being referenced from within the formulas
(in other words, can the formula in one cell of the range be produced by
copying another cell from the range into it)? If yea, then will all the
cells in the range have formulas?

--
Rick (MVP - Excel)


"Howard" wrote in message
...
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