MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Jo on January 11, 2002 8:00 AM

I had the answer to this, but my computer crashed and lost all my files. What is the ScreenUpdating command for a Macro that won't show all the steps you took when writing the Macro?

Posted by Richard Winfield on January 11, 2002 8:16 AM

The code is :

Application.ScreenUpdating = False

Remember to turn it back on at the end of the macro with:

Application.ScreenUpdating = True