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

  • Thread starter Thread starter BILL SPF
  • Start date Start date
B

BILL SPF

how can I create a formula that keeps the results of a cell that recalculates
a formula,without using 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy value from changing cells without VBA 1
=Trend question 1
CONCATENATE code 2
Special Copy, Paste Special macro 3
Find Copy Paste Special 3
Copy/Paste_Value problem. 5
VBA code to replace Past Special 4
Need help on this strange event 1

Back
Top