stop screen refresh
 

The best way is not to use activate and select,
but assuming that you have

application.ScreenUpdating = False
' current code
Application.ScreenUpdating = True

--
Regards,
Tom Ogilvy

"Gordon" wrote in message
...
The macro that I have developed is running slower than I would like
because
it involves a very large amount of printing to the screen. The speed of
the
macro is thus limited by the graphics card rather than the Intel
processor.

Is there any way of making the macro run in such a way that it only
refreshes the screen at the end of the macro?