Vb screenupdating

Thanks to tjeffryes' remark, I checked if I had any watch set and I didn't...

I re-insist as well on the fact the "NO there was no call to another sub procedure setting it to "True" because when debugging my procedure, I could clearly see the value of "Application.

I was watching the state of an object within the Workbook (the locked property of a specific style).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.Keep that on mind if you will execute anything which would take less time.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 .

Leave a Reply