Application screenupdating excel 2016

The attached has worked very well - Excel 2010 in Windows 10 The attached sub routine loops through a list of sheets and for each sheet calls in the arguement also shown.As the model has grown in size I have started to encounter the screen flickering as the macro jumps from one sheet to another - despite scren Updating being false and also the run time has gone from 1 minute to 4 minutes The net is awash with this problem and ideas on causes however the use of Select is commonly blamed Ignorance on my part means that I cannot alter the use of Select in my code to see if the flickering stops.

You will have to test this and loet me know if any errors occur and the line they occur on.

Good Morning Thanks for the quick response Re your comments Sensitivity issues precluded me attaching the relevant workbook and a mock up would not necessarilly be reflective of the complexity.

It happens when there is transition among excel files.

The same macro worked properly in win 7 with office 2010.

When the macro finishes, set the calculation mode back to automatic.

The following statement sets the Excel calculation mode to manual: If your code uses cells with formula results, turning off calculation means that the cells will not be recalculated unless you explicitly tell Excel to do so!I would appreciate if someone could give me guidance on how to circumvent the use of Select in this code It is so much easier if you attach an example workbook containing the code.I have attempted to edit your code but I cannot test it. Screen Updating-Property does not work properly in Excel 2016 / Win 10. The screen is updated after each step in VBA, although the Screen Updating is set to False. It would be nice to have this bug fixed as quickly as possible, since I have hundreds of Makros who depend on this property.I have a simple workbook (Book1) with a macro attached - macro written while using Excel 2010.Excel executes the default operation for these types of messages.

Tags: , ,