preventing screen updating with regression in excel

[DelShannon]

I'm running a long series of regresions in excel 2002 (excel 10, I believe) and cannot turn off the screen updating of the output range.

I have tried:

Application.ScreenUpdating = False

to no avail.

The DoCmd.Echo command seems to be unsupported by VBA in Excel l0.

The regression subroutine packaged with excel is "ATPVBAEN.XLA!Regress". I cannot find documentation related to it's arguments. Perhaps they overide the screen.updating command.

I'm trying to reduce the running time of the macro.

Any help would be greatly appreciated.

Thanks,

Del

 

[combo]

Probably it is not ScreenUpdating which makes calculations long. If you do a lot of regressions, you can try:
Application.Calculation = xlCalculationManual
(set to xlCalculationAutomatic at the end). This can prevent recalculations between regressions.

combo

 

[DelShannon]

Thanks for the tip, Combo.

I tried turning calculations off as you suggested but no effect. The output table gets re-written with each regression, and the screen along with it.

Any other suggestions?

Thanks,

Del

 

[Zathras]

Sounds like all you can do is make the window physically smaller, so there's less to paint. I.e., don't run full screen and have as few lines showing as necessary. Then enlarge the display when finished.