To display the Developer tab, click on File in the menu bar and select Options from the drop down menu.When the window appears, click on the Customize Ribbon option on the left.

vba screenupdating excel 2016-63

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.

I have attempted to edit your code but I cannot test it.

Thanks in advance TIPS FOR FINDING EXCEL SOLUTIONS 1.

Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder.

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.

If macro3 does turn screenupdating off but then turns it back on at the end, you'll see the screen redraw then. Simply removing Screenupdating = True from all the macros should resolve that. If your question is answered then please remember to mark it solved Computers are like air conditioners.

When the main macro runs it show all the process from the biggining not in the end of macro. If the next called macro (macro3) doesn't turn screenupdating off again, you will see everything it does because screenupdating is still on because of macro2.

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?

Click on the Developer checkbox under the list of Main Tabs on the right. Select the Developer tab from the toolbar at the top of the screen.