Useful VBA Snippets (Constantly Updated)

A collection of useful VBA Snipplets.

Miscellaneous code


Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual 'use with caution
Application.EnableEvents = False

'YOUR CODE

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
Application.EnableEvents = True

comments powered by Disqus