Subscript Out of Range Error

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

For some reason, I get the Subscript Out of Range Error each time I
open Excel for the first time. Once I answer the message, then I can
work with existing or new workbooks with no problem. Does anyone know
a straighforward (simple) way to get rid of this error for good? I
actually believe that I set something up accidentally--possibly in the
Format menu. HELP!!!
 
Just to add to Frank's reply:

Chip Pearson has some notes to help clean up this kind of error at:
http://www.cpearson.com/excel/StartupErrors.htm

Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)

Then one by one, you'll add one back and restart excel to see if that caused the
problem.

Then you'll decide what to do with the problem workbook.
 
Back
Top