View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default How do you update a cell after an operation on it.

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?