- still, I have that flickering with excel 2013-W8 and not with excel 2010-W7 since the main sub (and those called by it) has to open all those many workbooks, for reading data inside them, I'm starting to think flickering is due to this.but with no idea of why should that happen with excel 2013-W8 only.Don’t forget to reset the Screen Updating valsue as TRUE at the end of the macro.Please follow the below steps to execute the VBA code to save the excel file. Step 2: Press Alt F11 – This will open the VBA Editor.
If this does happen, you may need to repeat the line: Application.
It sheet that the user sees does not update until after the code is done running altogether.
code chunk that steps through the sheet rows looking for selected cells "") Then ' testing for selection status Worksheets("History Seeding").
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Screen Updating = True End If For j = 1 To 200000 ws. Finally I must add that those two Excel run on different machines: Excel 2010 with W7 and Excel 2013 with W8 I think that's all, for now you should avoid any code that selects or activates anything, work with fully qualified ranges instead of selection i believe that screenupdating can only be relied on to work correctly within the procedure it is called, if in doubt just put at the beginning of every procedure i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next Sub put Numbers In Cells() Dim ws As Worksheet Dim j As Long Dim resp As Integer Set ws = Active Sheet resp = Msg Box("Turn off updating? Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim previous Screen Update as boolean Call my Screen Update(False, previous Screen Update) 'to get the current setting into previous Screen Update Call my Screen Update(True, false) 'to set updating to false 'do your heavy code here and when finished: Call my Screen Update(True, previous Screen Update)maybe you have fiddled around with the code and thought the first "Call my Screen Update(True, previous Screen Update)" is useless/wrong?