Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen Refresh | Excel Discussion (Misc queries) | |||
stop screen refresh | Excel Programming | |||
stop screen refresh | Excel Programming | |||
refresh of screen -- commando | Excel Programming | |||
Turning off Screen Refresh | Excel Programming |