Subscript out of Range

  • Thread starter Thread starter ej
  • Start date Start date
E

ej

When I open excel or a worksheet, I receive a 'runtime
error 9'. I can't seem to figure this out, but if I
choose end on the popup error window the worksheet/book
seems to work fine. Has anybody seen this before?

Thanks in advance.
 
Well an automatic macro is running. Since it happens when you start Excel
(without opening a workbook explicitly) you should see what workbooks or
add-ins are being opened automatically when you start Excel. These can have
auto-running macros. The first place to look is under Tools, Add-ins.
Anything selected there is loading automatically. Also look in your XLSTART
folders. Anything in those folders is also loading automatically.

With Excel closed you should selectively unselect/remove these items to see
if doing so fixes the problem.
 
Back
Top