Loop that runs every five minutes

[Matis]

Hi, When I'm using the now function in excel, it does not update automatically.
Could I write a macro that will update the now function. Basically a macro that performs a calculate every five minutes.

Thanks is advance.
Matis

 

[Al Chara]

You can have the calculate option set to manual and have the recalculate before save option checked and then install the AutoSave add-in and have it autosave every 5 minutes.

Or take a look at the OnTime function.
_________________
Hope this helps.
Kind regards, Al.
This message was edited by Al Chara on 2002-04-05 10:29