optimization question

[Guest]

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

 

[Guest]

At the start of the macro set:

application.ScreenUpdating=False

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

application.ScreenUpdating=true

 

[Guest]

Thanks! That did the trick.

At the start of the macro set:

application.ScreenUpdating=False

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

application.ScreenUpdating=true