MS Excel has stopped Working

[Dabbles2018]

I have a Personal.xlsb file with several modules. I recently changed over from 2010 to 2016 (O365). Prior to, all macros in the Personal.xlsb file worked as they should with no errors. Each macro is a two step process. Step one, formats each tab of an individual spreadsheet and step two copies the formatted information from the individual spreadsheet over to an excel database. Now that I am using 2016, sometimes the macros work, but most of the time I get "MS excel has stopped working, a problem caused the program to stop working correctly". I have stepped out the code to where the crash occurs:

Do While Finished = False
ActiveCell.EntireRow.Delete shift:=xlUp

This same step in completed successfully in the step prior. I have been searching threads for days trying to find a solution. Why would it work in 2010 but only some of the time in 2016 (more not that so)? How can I find what code needs editing? Or any advice? Thanks in advance for any help!!!

 

[mole999]

just a thought > http://www.cloudpro.co.uk/collabora...ce-365-vs-office-online-what-s-the-difference

they are handled differently, local or in the cloud

whether that is the exact cause i'm not sure