Countdown Clock problem

[dealbanker]

Hello

My countdown clock in the Excel sheet is continually freezing for 1 - 3 seconds at a time and then resuming at the correct time. Or it will freeze and then jump through the digits to get through to the correct digits/time. There are a few seconds of normal countdown and it will repeat the problem

It only started today. I have tried rebooting. The GRUSS clock is acting normally.

Does anyone know what may be happening and what I need to do to rectify this? I rely on the clock to have regular second intervals for my VBA code.

Thanks

[GaryRussell]

It could be your VBA code keeping Excel busy so that BA cannot update it. If you put "Debug.Print Now" statements in your code you can test how long it takes to execute. If it is taking a few seconds then you need to try and make it more efficient.

[dealbanker]

Thanks for the tip Gary

However I am not getting any output with this.

The code is simple enough and the clock has worked perfectly for 2 days with this VB code -

-------------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Columns.Count <> 16 Then Exit Sub


Application.EnableEvents = False
Application.Calculation = xlCalculationManual

Range("AB5:AB35").Value = Range("AA5:AA35").Value
Range("AA5:AA35").Value = Range("f5:f35").Value


Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
End Sub
------------------------------------------------------------------------------

The problem is now stretching up to 5 seconds delay...

Any other suggestions?

Thanks

[dealbanker]

Creating a whole new sheet and reinserting the code seems to have given a temporary solution...

[dealbanker]

Solved
#DIV/0 was the problem, interfering with the timer for some reason