Narrowing Down What Caused a Crash
January 22, 2018 - by Bob Umlas
Sometimes Excel simply gives a message along the lines of “Excel has stopped working. We are sorry for any inconvenience.”
When you get such a message, you might press Ctrl + Alt + Delete and open the workbook again (hopefully having saved whatever work you had done!), wanting to step through the code to find the offending statement. When you single-step through the code, all may work fine, but when you run it at full speed, once again it may crash. How can you find the offending statement?