Learning about the ScrenUpdating property of the Excel application

[Almamba]

property I will appreciate it if anyone can help me to learn about the
ScreenUpdating property of the Excel application. Specifically, I would like
somebody to help me to enter Visual Basic statements that turn the
ScreenUpdating
property of the application object to FALSE to turn off screen updating and
TRUE to turn screen updating back on. I am working on a macro in Excel 2000.

Thank you very much in advance.

[Tom Ogilvy]

Application.ScreenUpdating = False
' it is now off


Application.ScreenUpdating = True
' it is now on

Look up ScreenUpdating in Excel VBA help for a written explanation.

--
Regards,
Tom Ogilvy

"Almamba" <Almamba@discussions.microsoft.com> wrote in message
news:9B482A14-F0B7-4E6C-90FC-36E55D8D5D1B@microsoft.com...
> property I will appreciate it if anyone can help me to learn about the
> ScreenUpdating property of the Excel application. Specifically, I would
like
> somebody to help me to enter Visual Basic statements that turn the
> ScreenUpdating
> property of the application object to FALSE to turn off screen updating
and
> TRUE to turn screen updating back on. I am working on a macro in Excel
2000.
>
> Thank you very much in advance.