Forum Discussion
Screen updating set to true but screen does not update.
Hello,
I recently ran into an issue with Excel Macros and VBA. I seem to have an issue with Screen Updating. After executing a macro the screen will “freeze.” After the “freeze,” I am able to “select” cells but the screen will not update. The Name Box and the Formula Bar, however, will update. I shared a screenshot of my screen after the “freeze.” You can see that cell A1 is selected with the green outline but the Name Box states that cell A4 is selected and the Formula Bar shows the contents in cell A4.
My code is pretty simple in that it selects specific ranges of cells and clears the contents one range at a time.
Application.ScreenUpdating = False
Range(“B3:E22”).Select
Selection.ClearContents
‘ More code
Application.ScreenUpdating = True
I have simplified my code to be
Sub testscreenupdating()
Application.ScreenUpdating = False
Application.ScreenUpdating = True
End Sub
When I comment out the ScreenUpdating=False line, my code works fine and the screen updates normally (obviously). So why is my ScreenUpdating= True not working? Please help!
Thanks,
Anthony
6 Replies
- JakespeareCopper Contributor
I'm having exactly the same issue, did you end up finding a way to fix it?
- For_AntCopper ContributorI did not find a fix. The issue resolved itself.
- JakespeareCopper Contributor
For_Ant yep same here - had the issue for a whole Tuesday, and then Wednesday it started working again...really weird