Thread: formula to save value of cell w/o copy- paste special-value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote