Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error '9'
Now I am losing my mind, after playing with some code, my excel will not load properly. I get run-time error '9' subscript out of range. Any help would be greatly appreciated. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error '9'
Mikegospo wrote:
Now I am losing my mind, after playing with some code, my excel will not load properly. I get run-time error '9' subscript out of range. Any help would be greatly appreciated. You mean this happens whenever you run Excel (not just with a particular workbook)? In that case it is presumably a problem with a workbook that is opened automatically when Excel starts - could be a file in your XLSTART folder or an add-in. Do you get a Debug button on the message that will show you where the problem is? What is the line that is highlighted, if so? If you don't get a Debug button the problem is probably in an add-in or another protected file. Remove them all and try opening them one at a time until you detect the culprit. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error '9'
Oddly enough it was the exceltip add in and the choose sheet add in I got from this web site. Thanks for your help. I hope I can be helpful to others at some point. Helpless in Ohio! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
Receiving run-time error only part of the time | Excel Discussion (Misc queries) | |||
run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel |