Passing Multi-dimensional arrays in VBA

[sharpnova]

I have a two dimensional array of strings:

Dim testArray(3, 3) as string

I need to pass this to a function.

I've tried every combination of syntax possible for passing this to a function to no avail.

Function analyzeCell(ByRef currentArray(,) as String) gives "Expected"

Function analyzeCell(ByRef currentArray as String(,) gives "Expected: list separator or )"

 

[apeters]

This works for me:

function analyzeCell(strArray() As String)

Here's the code I used to test it:

Sub startHere()
    Dim strNamesArray(3, 3) As String
    Dim strTemp As String
    
    strNamesArray(2, 2) = "Fred"
    strTemp = fetchArrayItem(strNamesArray, 2, 2)
    MsgBox strTemp

End Sub

Function fetchArrayItem(strArray() As String, a As Integer, b As Integer) As String
    fetchArrayItem = strArray(a, b)
End Function

 

[sharpnova]

Thanks for your help. So in VBA, no matter what the dimensions of the array, is this how it gets parameterized?

 

[apeters]

As far as I can tell from the documentation (http://msdn.microsoft.com/en-us/library/aa243374(v=vs.60).aspx), the same syntax applies no matter how many dimensions there are.