View Single Post
 
Old 09-18-2019, 05:02 PM
poetofpiano poetofpiano is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2015
Posts: 25
poetofpiano is on a distinguished road
Default Application.ScreenUpdating Question

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!
Reply With Quote