Excel uses 100% CPU for 4 hours...

[StephanieD]

I have a program that takes 4 hours to run. That's fine sincethere are thousands or rows of data to process so I just let it run overnight.

But my tripple-nested loop is apparently coded so tightly :-) that Excel allows no breathing room for other processes that might need a little CPU time.

Is there a command I could put in my inner-most loop that would tell Excel to take a breather for a few thousands of a second. In Unix terms, I would like it to play 'nice'.

When I programmed in the early Macintosh days, it had a system() function that was considered 'considerate' to put in your loops. System() would allow the Operating "System" some time for housekeeping chores, etc.

Is there anything like that available in Excel's VBA?

I realize it would make the program slower and it make take even longer to run.

[Richard Schollar]

Hi

Take a look at the DoEvents() function in VBA help.

Richard

[shg]

You could insert DoEvents in your loop, or use the Windows Sleep API:

Please Login or Register  to view this content.

[royUK]

Maybe use sleep

Please Login or Register  to view this content.

[Phil_V]

I think 'DoEvents' will do this for you, best to read and check it though.

[StephanieD]

DoEvents worked great. Thanks guys.