Write-over a formula in a cell using, but preserve the formula.

[Tanner_2004]

I have a cell with this formula in it; it is actually in a range of cells (I11:K25) but the row number changes.

=IF($H11="Fully Functional", "N/A","")

The challenge or my questions is how do I preserve/retain the formula in the cell when a user writes over it and them later changes his/her mind and selects "Fully Functional" from a name range list (data validation list)?

Thank you for for reading and any help.

 

[dreid1011]

I have a cell with this formula in it; it is actually in a range of cells (I11:K25) but the row number changes.

=IF($H11="Fully Functional", "N/A","")

The challenge or my questions is how do I preserve/retain the formula in the cell when a user writes over it and them later changes his/her mind and selects "Fully Functional" from a name range list (data validation list)?

Thank you for for reading and any help.

You don't. A cell can contain a value or a formula, not both. While it may be possible to write the previous contents to another sheet (hidden perhaps) when the cell is changed with VBA, Excel cannot recall previous cell contents on it's own.