Excel 2016 screenupdating not working

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.

In Excel 2010, you could control whether or not the screen updates while a macro is running by setting Application. In Excel 2013, screen updating cannot be controlled in this way.

Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.

is your source for cost-effective Microsoft Excel training.

Then comment out the line which turns off screen updating and see what happens; you should find that you scroll down the sheet as the numbers get filled.

Screen Updating = True Try running it and you should see a short pause followed by column A getting filled with numbers.

This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.

You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating.

excel 2016 screenupdating not working-65excel 2016 screenupdating not working-90excel 2016 screenupdating not working-5

Dim row Counter As Integer For row Counter = 1 To number Of Employees 'Do some work If (some Condition) Then start Cell.offset(row Counter). Value = "something else" End If Next row Counter then the flickering stopped and the time to execute the loop went from a few seconds to much less than 1s. So if any of your cells in the loop return empty string, you could try using either of these lines.This means that the Excel screen can look like it has "gone crazy" while the macro is running.One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.Long-running, high-end Excel-based applications that I developed years ago and that run beautifully in Excel 20 look like Amateur Hour in Excel 20 because Application. The screen unfreezes apparently when VBA code copies a preformatted worksheet from the macro workbook into a new workbook, although other circumstances must trigger it as well. I’ve seen the threads on this subject that recommend “fiddling with the code” or “calling the code in a subroutine”. The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.

738

Leave a Reply