Unknown Reason for Code

[bhujanga]

I'm doing some update to an Excel workbook that another person originally made. I notice that he begins all of his macros with following code:

Dim PauseTime, Start
PauseTime = 0.5
Start = Timer
Do While Timer < Start + PauseTime
DoEvents
Loop

I don't know what the purpose for this code is and thought maybe it was something that is a good idea to put in for some reason. Any insights?

 

[macropod]

Seems like there may have been some performance issues on the system for which the code was originally written. It shouldn't be necessary.

Cheers
Paul Edstein
[MS MVP - Word]

 

[TheAceMan1]

How are ya bhujanga . . .

The [blue]calling routines[/blue] to these macros might shed some light. You'll have to check them out.


See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]