Vba status bar stops updating
When the VBA macro is executed, VBA processor fetched single line at a time.The tokens of the fetched line saved by virtual compiler are now interpreted and executed then next line is fetched and so on.We might say, "VB does not use pointers", but it is not true.
There are many ways to implement a garbage collector, but Visual Basic uses what is called the reference count method.If any other references point to the same object, the object will not be destroyed.Reduce the number of Lines: Avoid multiple statements especially when they can be clubbed into one line. Without a good logic, a good written VBA macro program has no value. Analyze the logic: Before optimizing the syntax, pay more attention in optimizing the logic.
For example - See these 2 macros When we save the macro, it is virtually compiled and unlike it's human readable form as we saw in VBE(Visual Basic Editor), keywords(the dark blue words which you cannot use as variable) are saved as three-byte token which are faster to process as machine understand them better and variables, comments and literal strings which are not either keyword or directive are saved "as is".