Type Mismatch: Array or User Defined Type Expected (121114)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q121114 SUMMARY
In Microsoft Excel, when a Microsoft Visual Basic for Applications
procedure passes the value of one array to another array, if the data types
of the two arrays are not compatible, you may receive one of the following
error messages:
Type mismatch: Array or User Defined Type Expected.
Compile error:
Type mismatch: array or user-defined type expected
These error messages are not clear. A more accurate error message is the
following:
Type mismatch: arrays not of compatible types
RESOLUTION
To make sure that the data types for both arrays are compatible, dimension
both arrays with the same data type.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbinfo kbProgramming KB121114 |
---|
|