i haven't explained myself clearly. i want to interrogate a cell whose
values are constantly being updated and store that instantaneous value as a
constant elsewhere. an analogy might be storing lap times in addition to
total time.

"Peo Sjoblom" wrote:

Do you mean that when you enter the formula it will become static?
Not possible, you can trick some formulas by using iteration like in this
example

http://www.mcgimpsey.com/excel/timestamp.html

look at the "using circular reference" part, otherwise you would need code

--

Regards,

Peo Sjoblom

"bk" wrote in message
...
paste special "values" work fine as a manual solution but how can I assign
an
instantaneous cell value as part of as formula?

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=499894