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.Screen Updating = True End Sub In Excel 2000 and prior, it was not required to turn Screen Updating back to true.What i do is i always turn it on once my work is done.2 questions you need to answer as a part of survey.
The parameters which we are going to learn are regarding application.screenupdate.
It is not required to turn on screen updating after writing of code is over as it would by default automatically gets turned on.
My tip of the day is from a bit of my own experience.
As you are learning to write code, you've probably learned that you can radically speed up your macro by turning off the screen updating while the macro runs.
Do you turn off the screen updating once the work is done?
Last question does the flickering screen appears after executing such code.