Can anyone show me how to change this to run lets say at 10:30 am?





You may want to play with Application.OnTime

Sub ScheduleMe()
Application.OnTime Now() + TimeValue("00:00:05"), "RunMe"
End Sub

Sub RunMe()
Beep
ScheduleMe
End Su

--
Message posted from http://www.ExcelForum.com