Excel 2016 application screenupdating not working

I turned off the debugger and tried the same code and it flickers between the books. But that shouldn't alter the way it works when a routine / function is run.

To evaluate this better, can you post a sample file which replicates the scenarios you explained above?

Hi folks, To speed up my macro i am doing Application. Screen Updating inside the Sub() it shows FALSE though I am not sure what exactly is happening here, and how to ensure Application.

excel 2016 application screenupdating not working-90excel 2016 application screenupdating not working-49excel 2016 application screenupdating not working-31

This means that the Excel screen can look like it has "gone crazy" while the macro is running.Although doing this can be instructive, after you get the macro working properly, it’s often annoying and can slow the performance of your macro considerably.Fortunately, you can disable the screen updating that normally occurs when you execute a macro.Screen Updating stays as False and speed up my macros Ideally, if Application.Screen Updating = False how do i differentiate that from Application.When I tried the same code on excel 2013, but Windows 8 the application.screenupdating = false stopped working only on the Windows or workbooks activate functions.

You must have an account to comment. Please register or login here!