Application.ScreenUpdating (Excel)

True if screen updating is turned on.

Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster. Remember to set the ScreenUpdating property back to True when your macro ends.

Application.ScreenUpdating = True