Excel VBA: Speed up macro execution

Speed up macro execution by turning off screen updating/flicker.

'Turn Off Screen Updating
Application.ScreenUpdating = False
'Optional: Refresh/Update screen manually when needed
Application.ScreenRefresh

'Your Code

'Turn On Screen Updating
Application.ScreenUpdating = True

Leave a Reply