Dim myArray as data type of another array

If I have an array array2() of a given type, say for example Single, or 开发者_StackOverflow中文版String, or any other type.

How do I define array2() such that it has the same data type as array1()?

something like this:

Dim array2() As TypeName(array1())

How about just Dim array2()? That leaves it as type variant.

declaring everything as variant can introduce a fairly significant performance hit in some situations. you could always try the DataTypeofArray function at this site:

http://www.cpearson.com/excel/vbaarrays.htm