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?

"Pete" wrote:

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