To clarify: I'm looking for my formula to update its calculation everytime
the variables it depends on are updated, ~and to record each calculation
separately~. At this point I'm manually typing the result in a cell, but am
hoping to be able to have Excel do this, without my typing or preferably
without even having to use a macro.

Is there a solution?

"Don Guillett" wrote:


Change it to a value
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"starflight33" wrote in message
...
How can I automatically record a single moment's result for a function to
preserve it, when future changes in variables accessed by the function
will
change it in the future?