I was wondering if there was anyway to write a macro so that a cell would hold current time and keep refreshing it so it was accurate. I have been working at it for while now.

donnie alexander

No. Macros run in response to actions, not constantly in the background.

To keep a time-piece updating (if you don’t have an ActiveX control that already does this), you need to trigger the update several times per second (if you are showing seconds) or every couple of seconds (if you are only resolving down to minutes).