compare 2 vba arrays

[peioz]

Is there a more elegant way of comparing 2 array than is shown below ?
I just want to check if the 2 arrays are exactly identical......

for i = 1 to 10

if array1(i)=array2(i) then.......

next i

TIA....

 

[Andrew Poulsom]

I don't know about more elegant, but it would be quicker to test for inequality and exit the loop when they don't match.

x = True
For i = LBound(array1) to UBound(array1)
   If array1(i) <> array2(i) Then
      x = False
      Exit For
   End If
Next i
If x = True Then
   MsgBox "Match"
Else
   MsgBox "Item " & i & " does not match"
End If

 

[peioz]

Yours look more robust to me.... I thought there would be some kind of match commando ...quess not.

Thanks !

 

[Andrew Poulsom]

If you don't need to know which item mismatches you could use the Join function (Excel 2000 and above):

If Join(array1, "") = Join(array2, "") Then
   MsgBox "Match"
Else
   MsgBox "Mismatch"
End If

 

[r.v.srinvas]

hello guys... here i hav a small prb relatd to string arrays.
i have two string arrays as string1=F1,F2,F4,F16,F3
and string2= F2,F11,F7,F8,F12,F3.F21 (these two arrys need not be of same size)
plz suggest me a code to VBE(visual basic editor).
make it asap
thanks....!!!

 

[xl_User]

If you don't need to know which item mismatches you could use the Join function (Excel 2000 and above):

If Join(array1, "") = Join(array2, "") Then
   MsgBox "Match"
Else
   MsgBox "Mismatch"
End If

I would reccomend to include such separator string (for example, "|" symbol) in Join function that prevents wrong answer.