on time procedure

[Nike6106]

Hi

I need to run a macro every minute in a spreadsheet.

I have tried using

Application.OnTime Now + TimeValue("00:00:59"), "updatespreads"

But it is not working. Any ideas? Does it need to be in a module, or sheet?

Dan

[dominicb]

Good afternoon Nike6106

The code you supplied will run the macro "updatespreads" in 59 seconds time - just running it once. If you want to keep on running it, you'll need to call it again from teh "updatespreads" macro, thus :

Please Login or Register  to view this content.

HTH

DominicB

[mus_mo2049]

DominicB

would it be useful it include the

DoEvents line so that it frees up for other actions during the 59 seconds?

[Nike6106]

that worked. thanks