Suspending Updates

[John McGraw]

Is there a way to suspend cell updates from VBA temporarily?

I am finishing up some VBA code that creates a report, it runs fine. But when I include formulas and analysis in the spreadsheet for this report, the VBA program runs VERY SLOW. The automatic cell updates between each data change are just too much.

I want to turn cell updates off at the beggning, and turn them back on at the end. How can I do that?

Thanks much,

John

 

[Barrie Davidson]

On 2002-03-04 18:36, John McGraw wrote:
Is there a way to suspend cell updates from VBA temporarily?

I am finishing up some VBA code that creates a report, it runs fine. But when I include formulas and analysis in the spreadsheet for this report, the VBA program runs VERY SLOW. The automatic cell updates between each data change are just too much.

I want to turn cell updates off at the beggning, and turn them back on at the end. How can I do that?

Thanks much,

John

You could try this:

Calculate
With Application
    .Calculation = xlManual
End With
'the rest of your code
With Application
    .Calculation = xlAutomatic
End With

Regards,