Macro - Prevent screen refresh
You are quite correct. try this:
application.screenupdating=false
'
'your code here
'
application.screenupdating=true
"Bharath Rajamani" wrote in
message ...
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,
|