Repeat macro on time interval

See Chip Pearson's http://www.cpearson.com/excel/OnTime.aspx

tusharm - thanks for the reply. i used the code suggested but now i'm getting an error when it is ran. again, i'm not a programmer so this is new to me. any help would be appreciated. thanks.

Sub StartTimer()
RunWhen = Now + TimeSerial(0, 5, cRunIntervalSeconds)
Application.OnTime EarliestTime:=RunWhen, Procedure:=cRunWhat, Schedule:=True
End Sub
Sub The_Sub()
Selection.QueryTable.REFRESH BackgroundQuery:=False
StartTimer
End Sub

Run-time error '1004':

Method "OnTime' of object_Application' failed

On Chip's page, look at the declarations above the StartTimer procedure.

Also, you changed the TimeSerial arguments. You should look up Excel VBA help to understand the implication of the change.

I think I got it to work. I see what I missed. So far it is freshing the page but until the webpage that is being quered is up (Tuesday - Stock Ticker) and running I won't know. Thanks again. This is a great website.