Excel 2016 application screenupdating not working
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?