VBA loop slow if another workbook open
You are welcome! Thanks for the feedback!
Stefi
€˛George€¯ ezt Ć*rta:
Much better. Thanks.
G
On Mon, 29 Sep 2008 05:09:01 -0700, Stefi
wrote:
Try this:
Application.Calculation = xlManual
Do
...
ActiveSheet.Calculate
Loop
Application.Calculation = xlAutomatic
Regards,
Stefi
€˛George€¯ ezt Ć*rta:
I have a longish do-while loop in a VBA fnc. (code, below) If only
this workbook is open, it completes in < 1 sec. If any other workbook
is open, execution time increases to many seconds. ...
|