Screen updating macro
If this does happen, you may need to repeat the line: Application.This is part 2 of the Macro Efficiency series where in we teach you how to code efficiently using Microsoft Excel VBA.This method which we are going to discuss today is recognized as one of the basic and the most important method for making the code efficient.
Excel & Word have the Screen Updating method thru which a developer can lock the main window from unnecessarily redrawing itself whilst the macro is being executed. If left alone, redrawing is not only ugly on the eyes it also takes more time for the macro to reach completion.
It is not required to turn on screen updating after writing of code is over as it would by default automatically gets turned on.
But just in case if you want to display a message to a user saying " the command is executed" or want to display a userform etc.
It will automatically turn onwhen the macro is finished.
Sometimes you want to turn on the screen updating afteryou have turned it off, e.g.