look for a dupe in a collection
Posted on 2013-12-11
I'm trying to see if there is a duplicate before I add it to the collection, but it's not catching it. Here is what I have.
Dim arrSRDirectorsSub5 As New Collection 'temp collection for loop
'check for dupes and warn
If arrSRDirectorsSub5.Contains(strClearUser & "," & strTitle) Then
MsgBox("We got a dupe " & strClearUser & "," & strTitle)
arrLowLevelKeepers.Add(strClearUser & "," & strTitle)