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

optimization question
 

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

optimization question
 

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