instantaneous cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably incredibly simple but I've been going in circles with it for
some time. I'm looking for a way to grab and hold the instantaneous value of
a cell whose contents are constantly being updated. Any thoughts?
 
You can "fix" the values of a cell by <copy>, then select another cell
(maybe in another sheet) and Edit | Paste Special | Values | OK. This
would leave the formula in the original cell to continue to update
itself.

Hope this helps.

Pete
 
thanks for the reply. this works as a "manual" solution but how can I assign
only the contents of a cell in a formula?
 
Back
Top