Assign Data Type to Array Dimension

[JYTS]

Hi, I have a 2D array, (1 to 50, 1 to 3) let's say. It is initialized in a single statement which copies from a worksheet. Is there a way to define the data type for each dimension of the array? For example (1 to 50, 1) is currency, (1 to 50, 2) is a string, and (1 to 50, 3) is a long. Thanks

[AB33]

I do not think so. Data should be the same type in an array. You can use variant data type which is the same as defining both types as the same.

[JYTS]

Gotcha. Thanks

[shg]

You can only read a multicell range into a Variant. When you do that, each element will take on a subtype of Empty, Error, String, Boolean, or a numeric type.

If the array is assigned using the Value property, the numeric subtype will be Double, Currency, or Date, according to the cell format.

If the array is assigned using the Value2 property, the numeric subtype will always be Double.