Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-29-2005, 12:37 PM
Matrix's Avatar
Matrix Matrix is offline Mysterious "Subscript out of range" error Windows 10 Mysterious "Subscript out of range" error Office 2010
Admin
 
Join Date: Jan 2005
Posts: 448
Matrix is on a distinguished road
Default

Something has to be different on this computer. The error means "your code is referring to an element in the code that does not exist." Such as:



- A non-existent sheetname
- A sheet number higher than you have, such as might be encountered by looking through each sheet and deleting some sheets along the way. Near the end since there are fewer sheets you get the error message.
- Outside the range of an array

Maybe, paste your code here is easier.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysterious "Subscript out of range" error MYOB and "Item.Send error" Outlook message peter_lambros Outlook 1 12-06-2008 08:24 AM
Excel error: "Too many different cell formats" enviroko Excel 0 01-09-2008 07:27 AM
"IF" "THEN" statements in Macros mfgeng_iss Misc 0 10-04-2007 07:31 AM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft