Delay update of sheets

[Bob]

Hi all:

In excel VBA, is there a way to freeze the updating of the sheets, make all
sort of changes, and then have it update by code? I am trying to make lots
of changes, but the screen flickers, and it takes too long. I was hoping to
delay the the update once I was done with all my changes. Thanks for all
your help.

Bob

 

[Gary Keramidas]

add these to the beginning of your code

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

and these at the end

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True

 

[Bob]

Thanks Gary.

add these to the beginning of your code

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

and these at the end

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True