"Run Time error 9 : subscript out of range" when I open excel, close excel

This is a VBA runtime error. You either have a bug in a VBA add-in, or a bug in code in your PERSONAL.xlsb file. This will need a lot more information to diagnose.

When you get the error message, does it give you the option to Continue, End, Debug? If so, click Debug, then note what line of VBA code is highlighted in yellow. Copy all of the code, and paste it into a post here, telling us which one is the highlighted line. After you do that, select the code in your post and click the "#" symbol on the edit panel to mark it as code for formatting.

Moved from Excel General

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.