View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default using loop in ontime

Do you mean

Application.Ontime Now+Timeserial(0,0,i),"some procedure"

--
__________________________________
HTH

Bob

"Subodh" wrote in message
...
I want to use the onaction property in loop
like using it with a variable
for i = 1 to 100
ontime(00:00:i)
someprocedure
next i