MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macros


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

Rick