Running macros in Excel 2016 - screen flickering

kit99

Active Member
Joined
Mar 17, 2015
Messages
352
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?
 
Do a Google search on "Excel VBA Progress Bar", and see if maybe that is something you can incorporate.

If your code is taking that long to run, I would highly recommend trying to speed it up by incorporating using the things I told you above, as well as shutting off Automatic Calculations until the very end also.

I will look into it.
Thanks a lot for responding to my thread and for all your advice! :)
 
Upvote 0

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You are welcome.
I hope at least some of it helps!
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top