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