Hi,

This question is not clear to me. If you have cells with formulas and then
you type on the formulas you will loose the formulas, if you then clear the
content of the cells the formulas will not reappear. Is that what you really
want to have happen?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ra" wrote:

Please can you help with the following problem:

I would like to apply formulas in say Row 5, to the following cells:

F5, H5, J5, K5, O5, P5, T5, U5, Y5, Z5.

These formulas are the copied from Row 5 to Row 10,000.

The problem is, if I make a mistake in inputting data and I then need to
clear the contents of a cell or an entire row, the formulas are lost in that
row. How can I ensure that the formulas are not lost and still able to input
data in the cleared cells.

Mnay thanks,