When I start Excel I get the message "Subscript out of range". There is NO error number. This happens whether I'm opening a blank workbook or an existing workbook.
When I start Excel I get the message "Subscript out of range". There is NO error number. This happens whether I'm opening a blank workbook or an existing workbook.
It sounds like you may have a personal.xls workbook that is opening by default when you launch Excel.
To check, open the VB editor (ALT+F11) and look for an entry in the left-hand column similar to 'VBA Project (Personal.xls)'. Double-click that entry and see if there is any code entered in the code window on the right. If so, delete any offending code.
You can also check to see if a personal.xls file exists in the folder:
C:\Documents and Settings\<<your user name>>\Application Data\Microsoft\Excel\XLSTART
and delete it if you think there shouldn't be any personal macros stored in there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks