Jagged Arrays as parameters for vba sub

Question

I want to create a Sub in vba that has an Array as parameter. The following code works:

Sub phase1State(ByRef arr() As String)

Now, I want that parameter to be an array of arrays, or jagged array, how can I do that?

Thanks!

Magic word here is variant. A variant Array can store and Array. And can be passed as param — B.G.
– B.G., Commented Apr 29, 2016 at 10:39

gembird · Accepted Answer · 2016-04-29 11:19:32Z

4

Sub test()
    Dim jagged As Variant
    ReDim jagged(1 To 3)
    jagged(1) = Array(1, 2, 3)
    jagged(2) = Array(4, 5, 6)
    jagged(3) = Array(7, 8, 9)
    phase1State jagged
End Sub

Sub phase1State(ByRef arrJagged As Variant)
    Debug.Print arrJagged(2)(2) ' 6
End Sub

edited Apr 29, 2016 at 11:19

answered Apr 29, 2016 at 11:00

gembird

14.1k5 gold badges39 silver badges54 bronze badges

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

Comments

Karthick Gunasekaran · Accepted Answer · 2016-04-29 10:29:46Z

1

Sub Arraycheck()
    ReDim Arr(3) As String
    Arr(1) = "1"
    Arr(2) = "2"
    Arr(3) = "3"
    Call parameter(Arr())
End Sub
Sub parameter(getarr() As String)
    Debug.Print getarr(2)
End Sub

answered Apr 29, 2016 at 10:29

Karthick Gunasekaran

2,7231 gold badge17 silver badges26 bronze badges

Collectives™ on Stack Overflow

Jagged Arrays as parameters for vba sub

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related