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


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


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


Formatted | Unformatted
  1. Application.ScreenUpdating = False
  2. Application.Calculation = xlCalculationManual
  4. .. your code ..
  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