"Delay" function in Excel
Hello,
i would like to know if there is a way to have a (non-freezing, it has
to NOT freeze Excel) delay function in Excel (beside the loop with
DoEvents).
The problem is that i have a Macro that must "sleep" for 1 second, then
run, then sleep for 1 second, then run, and so on... but with a DoEvents
loop between each execution the CPU use is ALWAYS 100%.
Is there a not so CPU-hungry way to do it?
Thank you,
Luca
|