Vba screenupdating not working
When VBA works with data, execution speed depends on the number of bytes VBA has at its disposal.
In other words, the fewer bytes data uses, the faster VBA can access and manipulate the data. If speed is critical, use the Long data type instead.
The way out of this frozen state is simple: Go back to the VBE, and execute the following statement in the Immediate window: If you have a worksheet with many complex formulas, you may find that you can speed things considerably by setting the calculation mode to manual while your macro is executing.
When the macro finishes, set the calculation mode back to automatic.
By John Walkenbach VBA for Excel 2016 is fast, but it’s not always fast enough.
(Computer programs are never fast enough.) Keep reading to discover some programming examples you can use to speed up your macros.
For example, if you have a variable named My Var, you can assign a number of any type to that variable.
Your code runs faster if you use the With-End With structure.
An additional benefit is that your code may be easier to read.
If you use an object variable, you can declare the variable as a particular object type.
Here’s an example: Do you need to set a number of properties for an object?
In many cases, you can start a macro and then go hang out in the break room while Excel does its thing.