accessing a two dimentional collection array
I was wondering how you use elements to access a multi-dimensional array. I'd like to search through my array, but I'm not sure of the syntax when dealing with a two-dimensional array. Below is a snipped of the code I'm attempting to write.
Dim AcctTotals() As Variant
' now create the array to hold the totals
ReDim AcctTotals(NumOfRows, 1)
For Each element In AcctTotals
If element(what goes here ??) = Empty Then
element(and here) = AcctCode
Exit For
End If
Next element
|