run time error '9' - subscript out of range

  • Thread starter Thread starter Dana
  • Start date Start date
D

Dana

I have a simple program that dumps data into an Excel 97
worksheet. Recently, I tried to open the program (it
automatically opens the particular worksheet from Excel
97)and I received the message "Run-time err '9':
Subscript out of range" and then the program closed.

I think there is a problem with the accessibility of the
Excel workbook because when I tried to open the program
worksheet using Excel 97, it gives a message that it will
open as read only. This computer only has one user
signed on as an Administrator under Windows 2000 so, I
don't see how access could be restricted. Also, the
workbook is not under protected or restricted access
status of any kind. Anyone heard of this or have a
solution? Thanks to you all!
 
Hi Dana:

It would be helpful if you posted the relevant code and indicated which line
throws the error.

Regards,

Vasant.
 
Back
Top