You must set the Screen Updating property to True when the procedure finishes or when it stops after an error. Turn off automatic calculations: Whenever content(s) of a cell or range of cells are changed, the formulas dependent on them and Volatile functions are recalculated.
You can increase the speed of some procedures by keeping screen updating turned off.
Calculation = xl Calculation Manual Stop Events: Use Application.
Avoid 'Screen Flickering' or 'Screen Repainting': Use Application. So streamline your program logic and get the best performance of macros.If you're going to work with another application, such as Word, declare your OLE object directly, rather than as an Object type variable.By doing so, a great deal of overhead is done at compile time ("Early Binding") rather than at run time ("Late Binding").o We modify any of the properties of the Page Setup object in a VBA macro.
Refer to this Microsoft article for more details - Use 'WITH' statement when working with objects: If we have to access an object's properties and methods in several lines, we must avoid using object's name or fully qualified object path again and again. Without a good logic, a good written VBA macro program has no value. Analyze the logic: Before optimizing the syntax, pay more attention in optimizing the logic.You can use Excel's standard worksheet functions in your VBA code, rather than writing the functions in VBA.Since these are fully executable instructions in native code, rather than interpreted VBA code, they run much faster.Normally, Excel will recalculate a cell or a range of cells when that cell's or range's precedents have changed.