Forum Discussion
about Application.ScreenUpdating logic
So I assume you are familiar with this classical code above. I have 2 questions: (1) It seems, even without the last ScreenUpdating=True, when VBA end, screen will update anyway? So is this...
I don't know the cause of this behavior, nor Microsoft's official stance on it.
In my experience ScreenUpdating usually resets itself to True even if the code doesn't explicitly do so, but like you I have encountered situations in which the Excel windows wasn't updated. So it's best to include Application.ScreenUpdating = True, and to use an error handler to ensure that this line will always be executed.