Public Function ArrayCompare(A, B) As Boolean Dim I As Integer, J As Integer ArrayCompare = True For I = LBound(B) To UBound(B) Dim Found As Boolean Found = False For J = LBound(A) To UBound(A) If A(J) = B(I) Then Found = True Exit For End If Next If Not Found Then ArrayCompare = False Exit For End If Next End Function