Compare two tables in VBA

[mr2bart]

Hi,

I am stuck on one point.
I want to compare directly 2 VBA tables, I even do not know if possible: here code:

test1 = sheet(1).range("B2:f2")
test2 = sheet(2).range("C10:G10")

I want to compare test1 and and test2.

Can I do directly :
if test1 = test2 then
do something
endif

It seems it does not work.
Where is the problem?

Thanks

 

[Fluff]

Something like

Sub Compare()
   Dim test1 As Variant, test2 As Variant
   test1 = Join(Application.Index(Sheets(1).Range("B2:f2").Value, 1, 0), "|")
   test2 = Join(Application.Index(Sheets(2).Range("C10:G10").Value, 1, 0), "|")
   If test1 = test2 Then
      MsgBox "OK"
   Else
      MsgBox "Not OK"
   End If
End Sub

 

[mr2bart]

Thanks! it works!

 

[Fluff]

You're welcome

 

[mr2bart]

I have additionnal question to understand better. On Application.index(...), what's the meaning/function of ,1 and ,0 ?
Thanks

 

[Fluff]

The 1 specifies row 1 of the array & the 0 returns an array of values for the entire column https://exceljet.net/excel-functions/excel-index-function

 

[mr2bart]

Oh! yes, OK, same as the worksheet function. Thanks again!

 

[Fluff]

You're welcome

 

[Musto85]

I'll reopen this thread as I would like to do the same here but instead of comparing just one row (B2:F2) with another row (C10:G10) I would like to compare two whole tables (In different sheets) with range of one table A2:F300 and range of second table A2:F300, is this possible with an adaptation of the above code please?

Thanks in advance

 

[Fluff]

As this is a completely different question, you need to start a thread of your own. Thanks