Application screenupdating not working vba
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.Whereas previously the flickering caused by seeing the sheets as the code was working through has gone now it flickers between a blank excel sheet and my screen-saver. There were only 4 de-bugs - surprisingly few considering you had nothing to validate with I do appreciate the difficulty of your trying to this 'in the dark' and I would understand if you feel this is too constrained.I have tried moving the code to another procedure and doing Screen Updating = False Call Routine Screen Updating = True This has not worked.I tried adding Doevents after the screenupdating statements and that has not worked either.I am sure that the coding could be improved but you don't add any notes to explain in the code.How will you remember what it is doing when you come back to this code later?
I have attempted to edit your code but I cannot test it.
So from my viewpoint Screen Updating is not working correctly.
This is an issue because when activating some sheets, I am doing things in the background that have been "Hidden" to this point but with screenupdating all ways "on" the user will see everything.
If you do, then the code will select the sheet when it hits that part, and it will then look like it's flipping through.
Hi all, Before I start, I will admit I posted this in a forum that helps me a lot with another Office product, but as of this post they were not able to shed any light on this issue.