G Guest Apr 5, 2007 #1 Everytime I open an Excel spreadsheet I get the message "Subscript out of range" It used to never do this before.
Everytime I open an Excel spreadsheet I get the message "Subscript out of range" It used to never do this before.
D Dave Peterson Apr 5, 2007 #2 Maybe you have an error in a macro that's in a workbook that opens each time excel opens. I'd look in the XLStart folder--or any addin that you've installed tools|Addins. Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp
Maybe you have an error in a macro that's in a workbook that opens each time excel opens. I'd look in the XLStart folder--or any addin that you've installed tools|Addins. Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp