Description:
This issue illustrates a problem shown in bug 149325. Hopefully ScreenUpdating is easier to fix as this is a smaller file illustrating the situation.

ScreenUpdating can be set to true/false to enable/disable the screen updating when code is run.

Disabling ScreenUpdating improves the speed of code execution. The code is:
Application.ScreenUpdating = False

ScreenUpdating can be enabled after the block of code with:
Application.ScreenUpdating = True

Steps to Reproduce:
The attached Microsoft Excel spreadsheet has two subroutines, ScreenUpdateTestWorks() and ScreenUpdateTestFails()

Actual Results:
Correct behavior: Subroutine ScreenUpdateTestWorks() show a sheet with all the cells look empty (as the screen is not updating) when the MsgBox states:
All the data is entered into the cells. The application will update the screen when you press OK to see the data.

Correct behavior: Subroutine ScreenUpdateTestFails() show a sheet with all the cells incorrectly showing populated when the MsgBox states:
All the data is entered into the cells. The application will update the screen when you press OK to see the data.

The only difference between the ScreenUpdateTestWorks() and ScreenUpdateTestFails() is that ScreenUpdateTestWorks() has the line
MsgBox "All cells in this sheet should be empty."

Expected Results:
Both subroutines should show a sheet with all the cells look empty (as the screen is not updating) when the MsgBox states:
All the data is entered into the cells. The application will update the screen when you press OK to see the data.


Reproducible: Always


User Profile Reset: No



Additional Info:
Attaching the ScreenUpdating.xls file in the next comment as unsure how to attach now.

Thank you