You will learn and understand much more by looking at Chip's examples and
doing it yourself.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Gary" wrote in message
...
can someone tell me the code please?

"Bob Phillips" wrote in message
...
Check out OnTime at http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Gary" wrote in message
...
How can I have a macro auto run after every 1 minute?