Forum Discussion

For_Ant's avatar
For_Ant
Copper Contributor
Jul 11, 2022

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

  • MLMark's avatar
    MLMark
    Copper Contributor

    For_Ant , just wondering if you found a fix for this?  Microsoft are saying the only fix is to roll back the office updates to build 15xx which isn't ideal.

     

    Mark

    • For_Ant's avatar
      For_Ant
      Copper Contributor
      I did not find a fix. The issue resolved itself.
      • Jakespeare's avatar
        Jakespeare
        Copper Contributor

        For_Ant yep same here - had the issue for a whole Tuesday, and then Wednesday it started working again...really weird

Resources