Screen updating macro
Fortunately, you can disable the screen updating that normally occurs when you execute a macro.
To turn off screen updating, use the following statement: The range is filled much faster, and you don’t see the result until the macro is finished running and screen updating is (automatically) set to True.
By John Walkenbach VBA for Excel 2016 is fast, but it’s not always fast enough.
(Computer programs are never fast enough.) Keep reading to discover some programming examples you can use to speed up your macros.
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.
This sometimes causes Excel’s application window to become totally unresponsive.To achieve this we need to add a single line of code to the subroutine, just below the variable declarations.It's probably also worth changing the colour that we're using so that we can see when things have changed. This time you won't be able to see the macro carrying out its tasks; once the subroutine has finished the screen will update once at the end to show you the final result.Definitely it will save you a lot of time, but you have to decide of you want/need to see what is happening when your code is running.
If you are still in am early stage of your program with many debuggers you will need to see haw the data changes to find problems.
To demonstrate the principle of this technique we'll need a small example procedure that makes lots of visible changes to the Excel workbook.