Quote Originally Posted by SamT View Post
You are using OnTime to run this every second. You record the time every second. . . In the same cells for an entire minute. Only then do you change Rows.


At least put all that "Clock" code in a Standard Module, only run it once a minute, (unless you just like to watch the Seconds tick by,) and use Explicit Sheet and Range assignments.
Need to watch the seconds to make sure the clock is running correctly. Furthermore, I tried with the "Clock" code in a standard Module like what you have mentioned but still could not get the result in workbook2 Cell C1 to C1440. If I use same workbook with different sheets, the clock get disturbed and the number will start to run wild.

I would appreciate if you could explain your recommendation/suggestion in a more simpler way as I have almost no knowledge about VBA programmes and not an expert in Excel. Thanks.