passing string as array name in VBA

Question

I want to pass array name as string.

 Dim i as Integer
 Dim arName as String
 Dim ar1(10) as Integer 'array of 10 elements
 Dim ar2(10) as Integer
 Dim ar3(10) as Integer

 for i = 1 to 3
     arName ="ar" & i
     arName(1)=34 ' I want 34 in every 1st element of all three arrays 
 Next i
 End sub

I am doing this as Array practice. How to pass Array Name as string is my question

See: stackoverflow.com/questions/27994108/…

DDV
– DDV

2019-06-03 08:04:39 +00:00
Commented Jun 3, 2019 at 8:04 — DDV
– DDV, Commented Jun 3, 2019 at 8:04

user11509084 · Accepted Answer · 2019-06-03 08:37:01Z

1

Just create a single multi-dimensional array

Dim i As Integer
Dim arr(1 To 3, 1 To 10) As Integer
For i = 1 To 3
    arr(i, 1) = 34
Next

answered Jun 3, 2019 at 8:37

user11509084

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

2 Comments

MR57 Over a year ago

No that is not what I intended. I want to check if array name can be passed as string like ar1(x,y) ar2(x,y) where ar1 ="ar" & i (i coming from iteration.)

user11509084 Over a year ago

No, you cannot do that in VBA.

Collectives™ on Stack Overflow

passing string as array name in VBA

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related