How do you update a cell after an operation on it.

Can you do a calculation on a cell, get the answer and then post it back to
the same cell?

You need to learn how to post and you need to learn patience to wait for an
answer. You need a worksheet_change event macro.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tony" wrote in message
...
Can you do a calculation on a cell, get the answer and then post it back
to
the same cell?

Not without using VB.

Sub CircularLogic()
Range("A1") = Range("A1").Value + Range("C1").value
end sub

You can then either assign the macro to a hotkey, a command button, or an
event (in VB)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tony" wrote:

Can you do a calculation on a cell, get the answer and then post it back to
the same cell?

My apologies. I forgot to mention that you *can* do it with just formulas, if
you turn off automatic calculation. (tools-Options-calculation, set to
manual, iterations to 1).

Now you could put in A1
=A1-C3
and everytime you press F9, XL would perform a calculation.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tony" wrote:

Can you do a calculation on a cell, get the answer and then post it back to
the same cell?