Turn Off Screen Updating

Turning off Screen Updating will speed up your macros by running all the steps in the background without the need to refresh your screen during the process. The line of code below should be put at the beginning of your macro.

Application.ScreenUpdating=FALSE

This is an Excel wide setting so you must remember to turn it on again before your Macro ends, use the same line of code just changing the FALSE to TRUE.