Excel screenupdating 0 an error occurred while updating the configuration airport
10-Jan-2021 10:44
if it was off at the start of the code, store that and do not turn it back on at the end.
I fully agree and will begin to take heed, however, What is screen updating set to in Excel initially?
online dating army guys
And after all don’t turn screen updating on/off many times in some loop. And one more note (which you probably don’t want to hear) if you want it quick use C .Screen Updating = False 'swap between sheets 1/2 (need both sheets or this will crash) For i = 1 To numb Switches Sheets(1 (i Mod 2)). Screen Updating = True 'get results for part two results = results & vb Cr Lf & "Screen Updating IS disabled: " & Format(Time - start Time, "hh:mm:ss") & " seconds" 'show results Msg Box results End Sub Firstly I've been using the script written by Richie (UK) Post #7 Here It simply iterates through a loop changing the value of i in one cell.I have changed it slightly so it loops 10,000 times and I execute it 10 times for sample size.Anyone know how to ensure no updating happens even if macro triggers additional macros to run? They do BUT the running of the second macro seems to start with updating = true. Lets assume for a moment that it is the setting back to true at the end of the secondary macro that is causing the issue, should I apply an updating check at point(s) when the macro returns to the originally called code? NEW QUESTION - If I do not set updating back to True how can that negatively affect the spreadsheet?
When I break the code to debug, updaing unlike Enable Events seems to have no effect on the remaining functionality of the woorkbook if I do not set it back to True. Can updating be set to false and be left like that without ever setting it back to True? When stepping through the code, the setting of Screenupdating is irrelevant - you will still see the code working. It is not good practice to blindly set screenupdating back to true at the end of every sub.then copy your original sheet and special paste it as values only into the sheet you format as numbers only.
