.Contains() method with ArrayList second dimension

I have this code:

Set AR1 = CreateObject("System.Collections.ArrayList")
Set AR2 = CreateObject("System.Collections.ArrayList")


    AR1.Add CP32.EmpNumbers '// A range passed from a class module, which creates a 2nd dimension
    AR2.Add PP32.EmpNumbers '// Same as above


    For Each aVar In AR1(0)
        If Not AR2(0).Contains(aVar) Then .Columns(1).Find(aVar).Offset(0, 6).Value = "Y"
    Next aVar

(I've simplified the code to highlight the problem - I'm not using ArrayLists for no reason!)

Now, the

AR2(0).Contains(aVar)

doesn't appear to be a plausible method - so how can I check if AR2(0) contains the item from AR1(0)?

Do I need to dump AR2(0) into a single dimension array and check that instead?

Cheers guys

Re: .Contains() method with ArrayList second dimension

Cheers Stephen, I'll give this a try shortly and let you know how it went!

Re: .Contains() method with ArrayList second dimension

Hey Stephen, had to reverse the logic to

If Not IsNumeric(...

but seems to work a treat! Cheers

Oh, and ArrayLists (http://www.ozgrid.com/forum/showthread.php?t=167349) SUPER cool stuff :cheers: