Macro - Prevent screen refresh
Bharath:
Application.ScreenUpdating = False
'...
'Your code in Here
'...
Application.ScreenUpdating = True
HTH
Duncan
Bharath Rajamani wrote:
Is there a way to prevent the workbook screen display getting refreshed as a
macro runs, and make the macro run in the background without refreshing the
worksheet display.
Maybe it runs faster that way.
Rgds,
|