disable screen refreshes
 

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

disable screen refreshes
 

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

disable screen refreshes
 

application.screenupdating = false
'your code
application.screenupdating = true
--
HTH...

Jim Thomlinson


"ybazizi" wrote:

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

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