How to identify duplicates in a VBA array

[roscoe]

I'm filling a 2D array with values (dynamically redim as I go) and need to see if a value matches a previously stored value.

The array is Array(1 to J, 1 to 9) and I'm comparing Array(J,7) to all previous Array(1 to J,7) to find a duplicate.

Ideas?

 

[shg]

    For i = 1 To j - 1
        If myarray(i, 7) = myarray(j, 7) Then
            '...
        End If
    Next i

I wouldn't use Array as the name of an array; it's the name of a function in the VBA library.

 

[roscoe]

Thanks.

(I don't name my arrays "array", that was just a simplification.)

 

[shg]

You're welcome.