If you’re getting a macro error message for troubleshooting your computer in Excel 2010, it’s time to check out these troubleshooting ideas.

 

 

Fixed a simple and complete Excel macro when receiving a terrible error message. Use the debug buttons to solve a compact problem in your code. How to permanently fix the problem, the F8 key stopped working on exit Not from a macro. What to do even if there is no project explorer list

Button For Debugging Error Messages

From time to time you will get a nice error message when you check that a macro is about to run. look like “runtime error” 9: index is out of The “range” shown below.

troubleshooting macros in excel 2010

There are currently 3 buttons available in this error message – Exit, Debug. and help.