Forum Discussion
For_Ant
Jul 11, 2022Copper Contributor
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 “selec...
Jakespeare
Jul 26, 2022Copper Contributor
I'm having exactly the same issue, did you end up finding a way to fix it?
For_Ant
Aug 04, 2022Copper Contributor
I did not find a fix. The issue resolved itself.
- JakespeareAug 04, 2022Copper Contributor
For_Ant yep same here - had the issue for a whole Tuesday, and then Wednesday it started working again...really weird
- safron85Mar 14, 2024Copper ContributorI just ran into this issue and landed here. Fortunately I've found a workaround.
a) 2nd to last line of procedure: application.screenupdating = True
b) last line of procedure: Range("A1").select (can be anything)
Hope this helps!