Here is a pic of the status bar while the macro is running. Once we use at the end of the code, it will revert to the default Excel message which is READY.When a workbook is in manual calculation mode, the workbook will not recalculate until you explicitly trigger a calculation.The idea is to place Excel into manual calculation mode, run your code, and then switch back to automatic calculation mode.While I’m thinking about this stuff, I’d like to share a few simple tips for speeding up your Excel VBA code. So feel free to comment and share any other performance tips you may have.Each time a cell that affects any formula in your spreadsheet is changed or manipulated, Excel recalculates the entire worksheet.
This flickering is Excel trying to redraw the screen in order to show the current state the worksheet is in.
Option Explicit Sub macro1() Dim i As Long, lrow As Long Application.
After the macro is finished, the status bar will show as follows – So similarly, you can update the status bar at different parts of the code, so that the user knows what is happening as the macro is running.
He is the lead developer of several VBA applications, including PDF VBA - a leading Excel Add-in for exporting Excel Objects, like charts and tables, to PDFs.
Discover more of his popular Excel Add-ins, including Mouse To Macro and CF Shapes, at his dedicated Excel Add-ins page.