Application screenupdating excel 2016
As the model has grown in size I have started to encounter the screen flickering as the macro jumps from one sheet to another - despite scren Updating being false and also the run time has gone from 1 minute to 4 minutes The net is awash with this problem and ideas on causes however the use of Select is commonly blamed Ignorance on my part means that I cannot alter the use of Select in my code to see if the flickering stops.
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.
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.
I want to try and speed up some of the exports as they are quite large and can take a while to complete. Screen Updating = False but get a "Method or data member not found" error. It is cool to be part of such and active and sharing community.
Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately.
When Access is exporting the data to Excel I can still see the spreadsheet tabs populating.
I was wondering if it was where I am putting the commands.
Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services.
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.