Screen Flickering in Excel

Question

For Excel VBA, with my code, I am facing heavy Screen Flickering when Macro runs and also it takes 10 mins to complete the macro run actually. I have lot of input data to be processed. Because of that, it takes too much time here.

How to avoid screen flickering in Excel macros. Please note that i am setting application.displayevents to false at the start and set it to true at the end here.

I have tried changing copy paste methods to speed up the macro, but it did not help me a lot. My macro is very long and contains multiple small macros inside here.

What are the methods to detect what is causing screen flickering and how to stop it completely.

Answer 1

Are you sure that you have the correct code to suppress screen updating? In your original post you said", i am setting application.displayevents to false". DisplayEvents is an incorrect command, and it should error because EnableEvents suppresses events. However, correct code to suppress Screen Updating is Application.ScreenUpdating = False.

Unfortunately, at this point in time, I cannot think of anything else that might be causing the problem.

Answer 2

Dear Sir,

I have tried all those methods with my code, but no help on this.

Regards

Answer 3

Try the following in lieu of application.displayevents

Application.ScreenUpdating = False

ScreenUpdating usually resumes automatically after processing is finished. However, can insert the following as the last command after processing is completed.

Application.ScreenUpdating = True