This also will make your macros run faster, updating the screen appears to take a lot of clock cycles, the macros that I ran before this would take several minutes to run before I turned off the updating.
Much of the activity that causes flicker also slows down execution. In most case this activity can be eliminated by having your code NOT select cells before operating on them.
There is no need when using VBA to select a cell to apply a value or format to it. However the macro recorder will record the selections as they are made. The best way to learn and optimise VBA is to clean up your recorded macros.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.