Advanced Search

Speed Up Excel Macro Execution

/ Published in: Visual Basic
Save to your folder(s)
Turn off screen updating, formula calculation and events in order to prevent Excel from doing all of them and speed up macro execution.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. Function turnEverythingOff()
  2.     Application.ScreenUpdating = False
  3.     Application.Calculation = xlCalculationManual
  4.     Application.EnableEvents = False
  5. End Function
  6.  
  7. Function turnEverythingOn()
  8.     Application.ScreenUpdating = True
  9.     Application.Calculation = xlCalculationAutomatic
  10.     Application.EnableEvents = True
  11. End Function

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.