Turning off screen update while macro runs

Hi,

I was wondering if there was a way to turn off the screen update while a macro runs, and then to turn it on again once it is complete. Also, does this help the throughut time at all?

Thanks for the help.

dancingflames,

Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"dancingflames" <dancingflames.1xzugf_1131143723.4311@excelforum-nospam.com>
wrote in message
news:dancingflames.1xzugf_1131143723.4311@excelforum-nospam.com...
>
> Hi,
>
> I was wondering if there was a way to turn off the screen update while
> a macro runs, and then to turn it on again once it is complete. Also,
> does this help the throughut time at all?
>
> Thanks for the help.
>
>
> --
> dancingflames
> ------------------------------------------------------------------------
> dancingflames's Profile:
http://www.excelforum.com/member.php...o&userid=27056
> View this thread: http://www.excelforum.com/showthread...hreadid=482357
>