I currently have a macro that kickes off every 4 min's my problem i
that it kicks off just at random times.. closer to every 4 second..
this is my code


Public dTime As Date
Sub MyMacro()
dTime = Now + TimeValue("00:04:00")
Application.OnTime dTime, "MyMacro"

Any Ideas?
Chri

--
chris656
-----------------------------------------------------------------------
chris6562's Profile: http://www.excelforum.com/member.php...fo&userid=1577
View this thread: http://www.excelforum.com/showthread.php?threadid=27528