When you’re debugging code, program execution sometimes ends somewhere in the middle without your having turned Screen updating back on.This sometimes causes Excel’s application window to become totally unresponsive.
Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application.
Screen Updating is turned on outside of the procedure.
“Used Cell” is defined as Cell containing formula, formatting, The above procedure work under normal circumstances, but it does not work in some cases where the data source was downloaded from other system.
In that case you should use the below procedure to clear all empty cells and then delete the row. Screen Updating = False For Each usedrng In Active Sheet.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
I am not doing anything with sheet names so I'm not sure how its relevant.
Close False End Sub I've renamed the active Workbook variable to current Workbook to avoid confusion.
Display Alerts = False Flicker Test Helper Application. I've tried a few Win Api functions like Lock Window Update as well as Set Window Pos to Top Most but neither seemed to work.