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
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.