Hi!
Is there a place where I can get a list of the descriptions of all the
error messages that visual basic has. Such as Run Time Error '5'
Also how would I know which macro it is associated with?
Thanks! Have a good Day!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=504231

Brian,
This bit of code prints out the first 100 error descriptions to the
Debug window.
Catherine

Sub test()
Dim ErrorNumber
For ErrorNumber = 1 To 100 ' Loop through values 1 to 100.
Debug.Print ErrorNumber; Error(ErrorNumber) ' Print error to
Immediate window.
Next ErrorNumber
End Sub

The result you get is :
1 Application-defined or object-defined error
2 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
22 Application-defined or object-defined error
23 Application-defined or object-defined error
24 Application-defined or object-defined error
25 Application-defined or object-defined error
26 Application-defined or object-defined error
27 Application-defined or object-defined error
28 Out of stack space
29 Application-defined or object-defined error
30 Application-defined or object-defined error
31 Application-defined or object-defined error
32 Application-defined or object-defined error
33 Application-defined or object-defined error
34 Application-defined or object-defined error
35 Sub or Function not defined
36 Application-defined or object-defined error
37 Application-defined or object-defined error
38 Application-defined or object-defined error
39 Application-defined or object-defined error
40 Application-defined or object-defined error
41 Application-defined or object-defined error
42 Application-defined or object-defined error
43 Application-defined or object-defined error
44 Application-defined or object-defined error
45 Application-defined or object-defined error
46 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
65 Application-defined or object-defined error
66 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
73 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
78 Application-defined or object-defined error
79 Application-defined or object-defined error
80 Application-defined or object-defined error
81 Application-defined or object-defined error
82 Application-defined or object-defined error
83 Application-defined or object-defined error
84 Application-defined or object-defined error
85 Application-defined or object-defined error
86 Application-defined or object-defined error
87 Application-defined or object-defined error
88 Application-defined or object-defined error
89 Application-defined or object-defined error
90 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 not call friend function on object which is not an instance of
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
100 Application-defined or object-defined error