smooth countdown

[plane_nerd]

greetings all, sorry if this is covered somewhere else if it is really basic.

i have a macro that loops through calculating to make a count-down timer work. the problem with it is that the screen flickers each time it calculates. It runs roughly like this:

Sub Countdown ()
For i = 1 to 100
Worksheets("Sheet2").Cells(i,1).Value = i
WaitHours = 0
WaitMins = 0
WaitSecs =1
Calculate
Next i
End Sub

Is there a way to smooth it out or make the code simpler?

Thanks in advance
K. B.

 

[plane_nerd]

Perfect! Thank you so much!

keane

 

[jeffreybrown]

You're welcome and thanks for the feedback