Excel application screenupdating not working

After the macro is finished, the status bar will show as follows – So similarly, you can update the status bar at different parts of the code, so that the user knows what is happening as the macro is running.

Here is a pic of the status bar while the macro is running.

If you have turned off screen updating using the line Application.

When you’re debugging code, program execution sometimes ends somewhere in the middle without your having turned Screen updating back on.

In this post I’m going to share with you the most important performance tips I know about.

There are tons of sites, pages, and people who are experts as well on this subject, have performed their own tests, and shared their results and ideas.

You can ask the code to display a status message on the status bar so that the user is informed about the current status of the code.

Here is a simple code which gives a message box showing the values in column A starting from row 2 to the last row.

791

Leave a Reply