formula to save value of cell w/o copy- paste special-value
 

how can I create a formula that keeps the results of a cell that recalculates
a formula,without using COPY-PASTE SPECIAL-VALUE.

formula to save value of cell w/o copy- paste special-value
 

With great difficulty.

Formulas are designed to return results and will change as the input values
change.

If you want the formula to quit updating at a certain point, you could use event
code to automatically delete the formula and leave the last value.

Need more details.


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 07:04:01 -0800, BILL SPF <BILL
wrote:

how can I create a formula that keeps the results of a cell that recalculates
a formula,without using COPY-PASTE SPECIAL-VALUE.