I'm sure this has been asked many times before.

Sub TimeTrigger()
Application.OnTime TimeValue("1700:00"), "UpdateDates"
End Sub

"UpdateDates" is a procedure that works fine on its own. But the
OnTime method fails to call it. Why? I'd appreciate any help. Thanks


--
jimmike1
------------------------------------------------------------------------
jimmike1's Profile: http://www.excelforum.com/member.php...o&userid=31076
View this thread: http://www.excelforum.com/showthread...hreadid=507511