Scriptorium

us fr nl




VBA : Display: Optimize calculation time by shutting of display during calculations   us


Options: Save as PDF | Save attached file | Toggle line numbers

Details:

Type: snippet
Added By: Rembo
Short Description:
To optimize the calculation speed for complex or many calculations you can stop refreshing the display until all calculations are done.
Added: Aug 10 2005 at 9:08 PM
Modified: Jun 13 2013 at 3:45 PM
Related URLs


Usage:

Use the commands at the beginning of a sub and don't forget to enable them again at the end of your sub.


Code:

Formatted | Unformatted
  1. Application.ScreenUpdating = False
  2. Application.Calculation = xlCalculationManual
  3.  
  4. .. your code ..
  5.  
  6. Application.ScreenUpdating = True
  7. Application.Calculation = xlCalculationAutomatic



User comments :

Add a new comment   Back to Top
Atom Feed
Contact | About This Application | Scriptorium Website