Can put in :

Application.ScreenUpdating = False

Then just make it true again at the end.
Also may want to disable automatic calculations for the duration of the macro if you have calculations which are updating as you go and slowing it down