Dim myArray as data type of another array

Question

If I have an array array2() of a given type, say for example Single, or 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())

PowerUser · Accepted Answer · 2011-03-07 20:09:41Z

2

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

answered Mar 7, 2011 at 20:09

PowerUser

11.8k20 gold badges67 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dmitrii I. Over a year ago

Ok, then my question is, how badly will the performance suffer or what will be the effect if I convert all single, integer and double arrays in my program to variants?

Community · Accepted Answer · 2018-05-08 21:49:49Z

0

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

edited May 8, 2018 at 21:49

CommunityBot

11 silver badge

answered Mar 8, 2011 at 3:18

Will Ayd

7,2044 gold badges39 silver badges43 bronze badges

Collectives™ on Stack Overflow

Dim myArray as data type of another array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related