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

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" <(E-Mail Removed)> wrote in message
news:ACCDE4BB-0137-470E-BA16-(E-Mail Removed)...
> 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
>
>

Thanks Gary.

"Gary Keramidas" wrote:

>
> 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" <(E-Mail Removed)> wrote in message
> news:ACCDE4BB-0137-470E-BA16-(E-Mail Removed)...
> > 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
> >
> >
>
>
>