Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Type Mismatch: Array or User Defined Type Expected
Article ID: 121114 - View products that this article applies to.
This article was previously published under Q121114
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.
These error messages are not clear. A more accurate error message is the following:
Type mismatch: array or user-defined type expected
Type mismatch: arrays not of compatible types
To make sure that the data types for both arrays are compatible, dimension both arrays with the same data type.
Steps to Reproduce Behavior
NOTE: The data type of both arrays is double..
Article ID: 121114 - Last Review: October 11, 2006 - Revision: 1.5