Using the Application.ScreenUpdating = False?
Hi again
My second question!
I am trying to stop the screen from flickering during calculation when program runs.
I have tried this by putting it at the beginning (false) and end (true) of a sub() but still flickers
Application.ScreenUpdating = False
My program has for loops that execute less then100 times and some if/else select/case statements. Some cells change
color and values are deleted aswell.
-its running on a p3
Any advice?
Application.EnableEvents = False seems to do a better job in the Worksheet_Change then the above but still get some
flickering
Thanks
Mike
|