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|
Use the commands at the beginning of a sub and don't forget to enable them again at the end of your sub.
- Application.ScreenUpdating = False
- Application.Calculation = xlCalculationManual
- .. your code ..
- Application.ScreenUpdating = True
- Application.Calculation = xlCalculationAutomatic
User comments :
|Add a new comment||Back to Top|