I've been running the same macros for years now, and it's been working perfectly in both Excel 2007 and 2010.
But now my job's updated to 2016, and when I try to run the same macro the screen is flickering.
When speed isn't a issue, I prefer to have "screenupdating = true", so that I can see what's going on.
But now the screen is both flickering, for periods it's just white, and now and then I can see cells beeing updated on the screen - without seeing the rest of the sheet/cells...
I've tried setting hardware graphics acceleration in my excel to "disabled", but it didn't help.
Problem is the same on both my private pc and my job-pc. Both have Windows 10 and Excel 2016.
Any ideas on how this can be fixed?
But now my job's updated to 2016, and when I try to run the same macro the screen is flickering.
When speed isn't a issue, I prefer to have "screenupdating = true", so that I can see what's going on.
But now the screen is both flickering, for periods it's just white, and now and then I can see cells beeing updated on the screen - without seeing the rest of the sheet/cells...
I've tried setting hardware graphics acceleration in my excel to "disabled", but it didn't help.
Problem is the same on both my private pc and my job-pc. Both have Windows 10 and Excel 2016.
Any ideas on how this can be fixed?