1

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

barbsan
  • 3,418
  • 11
  • 21
  • 28
MR57
  • 21
  • 2
  • 1
    See: https://stackoverflow.com/questions/27994108/naming-an-array-using-a-variable – Dean Jun 03 '19 at 08:04

1 Answers1

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
  • 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.) – MR57 Jun 03 '19 at 17:09
  • No, you cannot do that in VBA. –  Jun 04 '19 at 07:19