Delay update of sheets
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
--
Gary
"Bob" wrote in message
...
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
|