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

  • Thread starter Thread starter Tony
  • Start date Start date
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)
 
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.
 
Back
Top