If this does happen, you may need to repeat the line: Application.Screen Updating = False in other parts of your macro. Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To......You can use the Worksheet Function property in Excel VBA to access Excel functions. For example, place a command button on your worksheet and add the following code line: When you click the command button on the worksheet, Excel VBA calculates the average of the values in cell A1 and cell A2 and places the result into cell A3. You can manually recalculate the workbook by pressing F9. In most situations, you will set calculation to automatic again at the end of your code. To insert the formula itself into cell A3, use the following code line: Sometimes you may find it useful to disable screen updating (to avoid flickering) while executing code. You can instruct Excel VBA not to display alerts while executing code. For example, place a command button on your worksheet and add the following code line: When you click the command button on the worksheet, Excel VBA closes your Excel file and asks you to save the changes you made. To instruct Excel VBA not to display this alert while executing code, update the code as follows. As a result, Excel recalculates the workbook automatically each time a value affecting a formula changes.When the data refresh runs, all images dissappear on the screen, and even the color format of the cells changes from grey to white.Essentially, it's a blank white spreadsheet which appears for the duration of the refresh.
Simply add the following code line to achieve this.
The reason it speeds up code is because Excel no longer needs to repaint the screen whenever it encounters such commands as Select, Activate, Large Scroll, Small Scroll and many others. Screen Updating=False should be placed at the Start of your macro like shown below Note how we have set the Screen Updating back to True on completion.