Paul,

Put this line at the beginning of your code:

Application.ScreenUpdating = False

change false to true to switch back on again

Regards

Michael Beckinsale