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