Subscript out of range

J

Joe

When I open Excel a message appears "Subscript out of
range". There is not any problem if I click "Okay". What
is this message referring to and how do I eliminate it?
 
S

sandra

Hi,
Sounds like the file has a macro tied to the Workbook_Open
event, which references another file that's not open.
 
D

Dave Peterson

If you can see the code, you may want step through the Auto_Open or
Workbook_open routines.

My guess is that the developer referred to a worksheet that doesn't exist
anymore--either it was deleted or renamed:

worksheets("sheet1").select

would cause that kind of subscript error if sheet1 didn't exist anymore.

(But there are lots of other things that can cause it, too.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subscript out of range when importing into access 2010 from excel 0
Error Message "Subscript our of range" 1
Active Content/Macros 2
Subscript out of Range 3
how to eliminate Subscript out of range message every time 1
What causes "Subscript out of range" during Access import? 2
Select range from unopened workbook 7
Run-time error'9' Subscript out of range. How do I sort? Please 1

Top