Obviously you can use Application.ScreenUpdating to speed up the performance of an intensive macro:
Code:
Application.ScreenUpdating = False
' code of macro
Application.ScreenUpdating = True
My question is, what if you use Exit Sub somewhere in the middle of the macro? Do you then also need to put Application.ScreenUpdating = True in the middle of the macro, before the Exit Sub, as follows:
Code:
Application.ScreenUpdating = False
' code of macro
Application.ScreenUpdating = True
Exit Sub
' more code of macro
Application.ScreenUpdating = True
I have never added this third instance, but lately I have noticed Word using a steady 7% CPU usage, and in the Task Manager, the "Print driver host for applications" is displayed under the Word application whenever the high CPU takes place. I’m not sure if the two issues are related; if anyone has any suggestions, thanks so much!