Hi, I have a simple countdown code for a stopwatch however it runs
faster than every second
does anybody know how I can rectify this?
thanks


Sub clockwork ()

Range("e12") = Range("e12") - TimeValue("00:00:01")
If Range("e12") = 0 Then End

'runs event every 1 second
NextTick = Now + TimeValue("00:00:01")
Application.OnTime NextTick, "clock"
End sub