*Below code will help*
*
*
*Sub waitt()*
*For i = 1 To 5 'will run 5 times*
*'ur code*
*Application.Wait Now + TimeValue("00:00:05") '''will wait for 5 seconds*
*Next*
*End Sub*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sun, Oct 11, 2009 at 2:29 PM, Manish
This pointer should help: http://www.ozgrid.com/Excel/run-macro-on-time.htm
On Oct 11, 1:59 am, Manish Pansari wrote:
> Hello Friends,
>
> I want to run a macro continuously after every five minutes. Is there
> any option, by using that I can set macro run time and can run macro
> automatically?
