Run-Time error '9' starting Excel

[Paul Duane]

Hi,

Any help would be appreciated. When i start up my Excel 2003 (SP3) i get the
following error message:

Run-time error '9':

Subscript out of range

Any idea what would be causing it or how to get rid of it ?

 

[Jan Karel Pieterse]

Hi Paul,

Any help would be appreciated. When i start up my Excel 2003 (SP3) i get the
following error message:

Run-time error '9':

Subscript out of range

This is a default list of things-to-do when Excel exhibits (startup) problems.

Try opening Excel without any addins or hidden workbooks:

Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation

Quotes mandatory, Note you may have to change the path.

If your error disappears, there is either an add-in or a (hidden) workbook that
is loaded upon XL's start, which bothers you.

- Try locating the XLSTART directory, move everything from there.
- In XL: Tools, Addins, note the ones checked and uncheck them one at the time,
each time restarting XL
- In XL, Tools, options, general. Check if a path is entered after "Alternate
startup file location". Clear it.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com