The Screen Updating property controls most display changes on the monitor while a procedure is running.
When screen updating is turned off, toolbars remain visible and Word still allows the procedure to display or retrieve information using status bar prompts, input boxes, dialog boxes, and message boxes.
For a version of this tip written specifically for earlier versions of Excel, click here: Turning Off Screen Updating.
Many people write their own macros to manipulate the information in a workbook.
At every fiftieth line, the macro selects the line and refreshes the screen.