I would take another look at Chip's instructions and code:
http://www.cpearson.com/excel/OnTime.aspx

Then if you have specific questions about that code, post back. (Read through
the "stopping a time" section. Ignore the stuff after that.)

And for Chip's code, you can put all that stuff in a single module.

On 09/29/2010 15:09, Kfletch wrote:
Thanks in advance to anyone who can help me with this.

I have a simple excel macro written and want it to run every so often
(5 min / 10 min / 1 hour not sure yet) between the hours of 8:35:00 am
and 3:05:00 pm. I have been digging through related topics regarding
the OnTime method (here.. http://www.cpearson.com/excel/ontime.htm and
here.. http://www.ozgrid.com/Excel/run-macro-on-time.htm as well as
many more) and cannot really get my head around the easiest way to do
this.

Most of my confusion comes from where to write the code whether it be
in my current macro module, or in new modules / where and how the
sub's and sub of sub's go. Also I have trouble determining what is
actual code and what is a field I must define from much of the
information that is out there.

It would be much appreciated if anyone could help an amateur.

--
Dave Peterson