We might say, "VB does not use pointers", but it is not true.
"VB does not let you manipulate pointers" is more precise. If all we ever use are object pointers, how can we set the object itself to Nothing? When we set a reference to Nothing, something called the garbage collector kicks in.
However VBA compiler tokenizes the word but it does not compress the lines and each line is maintained as is ending with the 'Carriage Return'.
It is annoying for VBA processor as it needs to fully qualify the object each time. This concept tells us to use [A1] rather than Range("A1") and Range("Stock Range")(3,4) rather than Range("Stock Range").
(Isn't it annoying for us too when some work or something is told us again and again? The point here to understand is minimum qualifying of an object by VBA processor. Cells(3,4) Use vb Null String instead of ""(2 double quotes) : vb Null String is slightly faster than "", since vb Null String is not actually a string, but a constant set to 0 bytes, whereas "" is a string consuming at least 4-6 bytes for just existence.
When screen updating is turned off, toolbars remain visible and Word still allows the procedure to display or retrieve information using status bar prompts, input boxes, dialog boxes, and message boxes.
Screen Updating = The Screen Updating property controls most display changes on the monitor while a procedure is running.
Hide Page Breaks: When we run a Microsoft VBA macro in a later version of Microsoft Excel, the macro may take longer to complete than it does in earlier versions of Excel.