ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Error Message "Subscript our of range" (https://www.excelbanter.com/excel-discussion-misc-queries/137991-error-message-subscript-our-range.html)

gsmclang

Error Message "Subscript our of range"
 
Everytime I open an Excel spreadsheet I get the message "Subscript out of
range"
It used to never do this before.

Dave Peterson

Error Message "Subscript our of range"
 
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

gsmclang wrote:

Everytime I open an Excel spreadsheet I get the message "Subscript out of
range"
It used to never do this before.


--

Dave Peterson


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com