Access 2016 vba screenupdating dating interracial update
The idea is to use the first line near the beginning of your macro, and then use the second line near the end.Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.
Then comment out the line which turns off screen updating and see what happens; you should find that you scroll down the sheet as the numbers get filled.
In my case, when adding Application.screenupdating = False in my Workbook_Before Save code, it did not do it's job. yes a common occurrence is when you call another piece of code. In one particular instance I found an interesting fix: I had a Watch set.