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" wrote in message
...
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.