The other option is to use a simple line of code like: Application.
Screen Updating=False This will stop Excel having to repaint the screen each time the macro does something.
Many people write their own macros to manipulate the information in a workbook.
Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.
If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.