Error Codes
link - learn.microsoft.com/en-gb/office/vba/language/reference/error-messages
| Error No | Description |
| 0 | Invalid procedure call or argument |
| 1 | Application-defined or object-defined error |
| 3 | Return without GoSub |
| 4 | Application-defined or object-defined error |
| 5 | Invalid procedure call or argument |
| 6 | Overflow |
| 7 | Out of memory |
| 8 | Application-defined or object-defined error |
| 9 | Subscript out of range |
| 10 | This array is fixed or temporarily locked |
| 11 | Division by zero |
| 12 | Application-defined or object-defined error |
| 13 | Type mismatch |
| 14 | Out of string space |
| 15 | Application-defined or object-defined error |
| 16 | Expression too complex |
| 17 | Can't perform requested operation |
| 18 | User interrupt occurred |
| 19 | Application-defined or object-defined error |
| 20 | Resume without error |
| 21 | Application-defined or object-defined error |
| 28 | Out of stack space |
| 29 | Application-defined or object-defined error |
| 35 | Sub, Function, or Property not defined |
| 36 | Application-defined or object-defined error |
| 47 | Too many DLL application clients |
| 48 | Error in loading DLL |
| 49 | Bad DLL calling convention |
| 50 | Application-defined or object-defined error |
| 51 | Internal error |
| 52 | Bad file name or number |
| 53 | File not found |
| 54 | Bad file mode |
| 55 | File already open |
| 56 | Application-defined or object-defined error |
| 57 | Device I/O error |
| 58 | File already exists |
| 59 | Bad record length |
| 60 | Application-defined or object-defined error |
| 61 | Disk full |
| 62 | Input past end of file |
| 63 | Bad record number |
| 64 | Application-defined or object-defined error |
| 67 | Too many files |
| 68 | Device unavailable |
| 69 | Application-defined or object-defined error |
| 70 | Permission denied |
| 71 | Disk not ready |
| 72 | Application-defined or object-defined error |
| 74 | Can't rename with different drive |
| 75 | Path/File access error |
| 76 | Path not found |
| 77 | Application-defined or object-defined error |
| 91 | Object variable or With block variable not set |
| 92 | For loop not initialized |
| 93 | Invalid pattern string |
| 94 | Invalid use of Null |
| 95 | Application-defined or object-defined error |
| 96 | Unable to sink events of object because the object is already firing events to the maximum number of event receivers that it supports |
| 97 | Can't call Friend procedure on an object that is not an instance of the defining class |
| 98 | A property or method call cannot include a reference to a private object, either as an argument or as a return value |
| 99 | Application-defined or object-defined error |
| 298 | System DLL could not be loaded |
| 320 | Can't use character device names in specified file names |
| 321 | Invalid file format |
| 322 | Can't create necessary temporary file |
| 323 | Application-defined or object-defined error |
| 325 | Invalid format in resource file |
| 326 | Application-defined or object-defined error |
| 327 | Data value named not found |
| 328 | Illegal parameter; can't write arrays |
| 335 | Could not access system registry |
| 336 | ActiveX component not correctly registered |
| 337 | ActiveX component not found |
| 338 | ActiveX component did not run correctly |
| 360 | Object already loaded |
| 361 | Can't load or unload this object |
| 363 | ActiveX control specified not found |
| 364 | Object was unloaded |
| 365 | Unable to unload within this context |
| 368 | The specified file is out of date. This program requires a later version |
| 371 | The specified object can't be used as an owner form for Show |
| 380 | Invalid property value |
| 381 | Invalid property-array index |
| 382 | Property Set can't be executed at run time |
| 383 | Property Set can't be used with a read-only property |
| 384 | Application-defined or object-defined error |
| 385 | Need property-array index |
| 386 | Application-defined or object-defined error |
| 387 | Property Set not permitted |
| 388 | Application-defined or object-defined error |
| 393 | Property Get can't be executed at run time |
| 394 | Property Get can't be executed on write-only property |
| 395 | Application-defined or object-defined error |
| 400 | Form already displayed; can't show modally |
| 402 | Code must close topmost modal form first |
| 419 | Permission to use object denied |
| 422 | Property not found |
| 423 | Property or method not found |
| 424 | Object required |
| 425 | Invalid object use |
| 429 | ActiveX component can't create object or return reference to this object |
| 430 | Class doesn't support Automation |
| 431 | Application-defined or object-defined error |
| 432 | File name or class name not found during Automation operation |
| 433 | Application-defined or object-defined error |
| 438 | Object doesn't support this property or method |
| 439 | Application-defined or object-defined error |
| 440 | Automation error |
| 441 | Application-defined or object-defined error |
| 442 | Connection to type library or object library for remote process has been lost |
| 443 | Automation object doesn't have a default value |
| 444 | Application-defined or object-defined error |
| 445 | Object doesn't support this action |
| 446 | Object doesn't support named arguments |
| 447 | Object doesn't support current locale setting |
| 448 | Named argument not found |
| 449 | Argument not optional or invalid property assignment |
| 450 | Wrong number of arguments or invalid property assignment |
| 451 | Object not a collection |
| 452 | Invalid ordinal |
| 453 | Specified DLL function not found |
| 454 | Code resource not found |
| 455 | Code resource lock error |
| 456 | Application-defined or object-defined error |
| 457 | This key is already associated with an element of this collection |
| 458 | Variable uses a type not supported in Visual Basic |
| 459 | This component doesn't support events |
| 460 | Invalid Clipboard format |
| 461 | Method or data member not found |
| 462 | The remote server machine does not exist or is unavailable |
| 463 | Class not registered on local machine |
| 464 | Application-defined or object-defined error |
| 480 | Can't create AutoRedraw image |
| 481 | Invalid picture |
| 482 | Printer error |
| 483 | Printer driver does not support specified property |
| 484 | Problem getting printer information from the system. Make sure the printer is set up correctly |
| 485 | Invalid picture type |
| 486 | Can't print form image to this type of printer |
| 520 | Can't empty Clipboard |
| 521 | Can't open Clipboard |
| 735 | Can't save file to TEMP directory |
| 736 | Application-defined or object-defined error |
| 744 | Search text not found |
| 745 | Application-defined or object-defined error |
| 746 | Replacements too long |
| 747 | Application-defined or object-defined error |
| 1004 | Application-defined or object-defined error. This occurs when an error occurs which does not correspond to pre-defined error. These errors are often Excel (or application) errors that are propagated back to VBA. |
| 31001 | Out of memory |
| 31004 | No object |
| 31018 | Class is not set |
| 31027 | Unable to activate object |
| 31032 | Unable to create embedded object |
| 31036 | Error saving to file |
| 31037 | Error loading from file |
| 65536 | Invalid procedure call or argument |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext