When executing a macro you can watch everything that happens in the macro. This is good but when its all working it may be slowing down your macro. It can also be annoying to the user.
Use the following to disable the macro screen updating :
Application.ScreenUpdating = False
Then = True to switch it back on again.