Excel 2016 application screenupdating not working


Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application. Screen Updating is turned on outside of the procedure. Like you me too don't know the solution for this Please post a sample workbook with all the code; no pictures please.Screen Updating = False doesn't work when you step through the code.I guess the point is, if you're stepping through the code, you want/need to see what effect it is having on the worksheets.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.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 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. Range("$I$1") _ , False, False, False, False, , False PVTotal = Application. Sum(Range("B2", "B" & Last Record Row)) Imp Total = Application. Range("$C$1", "$C" & Last Record Row), False, True, , sht. 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.

When I have a final version of my code I always write up the detail, with comment, in a separate Word Document - just what I do for sensitive workbooks I will test the code as quickly as I can Thanks I have run the code and it successfully extracts the data for filters 1 and 2 but for filter 3 the results are corrupted in that it appears not to be looping through each sheet, that has content, 7 seven times also the extracts are incomplete.

How will you remember what it is doing when you come back to this code later?