Hi all,
How do I switch graphics on/off in function codes in excel I'm filling columns with data with my macro and to speed up the process I would just like to show the final result when every cell has its number. For the moment it adds a number to a cell I displays it immediately.
Any ideas
Best regards
Jonas
Switch graphic on/off in Excel
agenda9533
Just what I was aiming for, thanks a lot!
Best regards
\Jonas
Ehsan_AIUB
Hi Jonas
A good way to speed up the process is to turn the Calculation mode to Manual while loading the cells, and set it back to Automatic afterwards.
Application.Calculation = xlCalculationManual ' to turn it to manual
and
Application.Calculation = xlCalculationAutomatic ' to turn it back to automatic
If you want to hide what you are doing then you could make another sheet active.
Regards
Peter Mo.
mrmckeb
To do it properly, you can set the ScreenUpdate property of the Application to be false and turn it back to true after you finish.
Application.ScreenUpdating = False
Aslo, you can also turn the interactive mode false which will disable the user input.
Application.Interactive = False