optimization question

I saw some code once that turned off screen refreshes in a workbook until a
macro complete running. I can't remember how that was done. Does anyone
have any ideas?

Thanks

At the start of the macro set:

application.ScreenUpdating=False

At the end (or in your eeeor trap) set:

application.ScreenUpdating=true

"ybazizi" wrote:

> I saw some code once that turned off screen refreshes in a workbook until a
> macro complete running. I can't remember how that was done. Does anyone
> have any ideas?
>
> Thanks

Thanks! That did the trick.

"AA2e72E" wrote:

> At the start of the macro set:
>
> application.ScreenUpdating=False
>
> At the end (or in your eeeor trap) set:
>
> application.ScreenUpdating=true
>
> "ybazizi" wrote:
>
> > I saw some code once that turned off screen refreshes in a workbook until a
> > macro complete running. I can't remember how that was done. Does anyone
> > have any ideas?
> >
> > Thanks