You could use OnTime to run a macro at a specified interval. In this
example, "Test" will run "Test2" after 10 seconds. Then, when Test2 runs, it
will call the first macro and the process repeats.


Sub Test()
Application.OnTime Now + TimeValue("00:00:10"), "Test2"
End Sub

Sub test2()
MsgBox "Hello"
Call Test
End Sub


"as_sass" wrote:


Hi!

I have searched this forum a number of times for a definite answer on
how to time macro execution, but have not found anything that helped.

Problem I have:

Run macro either at certain time(s) of day or in certain time interval
(whichever is easier).

Preferably using really easy code in which I understand what to
substitute to change the time interval, as I'm not too familiar with
the whole VBA thing.

Anybody got any (simple) ideas?

Thanks!

sass


--
as_sass
------------------------------------------------------------------------
as_sass's Profile: http://www.excelforum.com/member.php...fo&userid=9065
View this thread: http://www.excelforum.com/showthread...hreadid=477036