SparksEdge: How to speed up your code in VBA

Today I will show you how to speed up your code in VBA

'Put this right after your sub macro()
Application.ScreenUpdating = False
Application.DisplayAlerts = False

'Put at the end just before the End Sub
Application.ScreenUpdating = True
Application.DisplayAlerts = True