| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last cell, copy, paste special, loop | Excel Programming | |||
| Prefacing a Copy/Paste Special formula with text | Excel Worksheet Functions | |||
| Create new sheet from cell-info and then copy/paste special | Excel Programming | |||
| Copy Paste Special Link Cell Problem | Links and Linking in Excel | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Linear Mode
