Example using XL2000, my 2.16MB file was saved as a 3.85MB file and took 45 seconds to save first time with Save As, and over one minute with subsequent Save.
The save time for this large file as a normal XL2000 file is 10 seconds. If you are saving as Microsoft Excel 97-2000 & 5.0/95 Workbook *you will see the following Microsoft Excel 5.0/7.0 saving on your status bar where you normally see Ready toward the end of the save then you are saving in multiple formats.
What I personally was missing was a simple, comprehensive, short overview of how the performance of VBA macros can be improved without needing to read through long articles on how the Excel compiler works bla bla bla.
That is why I gathered all VBA performance guidelines into this single post which contains all the known ways of Improving VBA Performance, organized by impact on VBA Performance.
It will help you to stop screen flickering or Screen updating while executing or running macro.
So that it will greatly speed up your code and saves lot of time.
Because of the nature of such problems, it is important to provide feedback when you solve your problem by replying back to the thread so that others can be helped and so that pages such as this can show relevant information.
This is fine as long as your macro is small, but if it is big, Screen Updating can take a long time, and turning it off can make VBA code run faster.
Let’s prove that: This code for me takes 0.64 seconds to run Now, lets turn off Screen Updating and see the difference: 0.64 seconds vs 0.078 seconds The faster VBA code runs 8 times the speed of the slow code.
We need to Optimize VBA codes to run macros Faster while running VBA macro for efficient VBA programming, to generate good quality of output, to save time, easy to understand codes, etc.
We can fasten the execution of macros or VBA Procedures or functions by following or using the below tips or technics.