disable screen refreshes
Hi Ybazizi,
The last line should read:
Application.ScreenUpdating = True
---
Regards,
Norman
"Norman Jones" wrote in message
...
Hi Ybazizi,
Try:
Application.ScreenUpdating = False
'Your code
Application.ScreenUpdating = False
---
Regards,
Norman
"ybazizi" wrote in message
...
I recall seeing a way of disabling updates to the Excel application window
temporarily while a macro runs, so as to improve the efficiency of
running
macro. Only, I can't recall what the function was that accomplished
this.
Can anyone point me in the right direction?
Thanks,
Y
|