title: Comparing two Arrays with excel VBA
body: <p>As for the problem, I need to be able to compare all data in Variant array A to all data in Variant array B. I know I need some kind of double loop (so that every A value is checked against all B values), but I can't figure out how to do it. Here's what I have so far:</p>
  
  <pre><code>Sub Button_Click()
  Dim trgtRange As Variant
  Dim tempRange As Variant
  Set myRange = ThisWorkbook.Sheets(1).Range("L:L")
  For Each cell In myRange
          If IsEmpty(cell) Then
              ActiveCell.Offset(-1, 0).Select
              currentRow = ActiveCell.Row
              Set trgtRange = Range("L2:L" &amp; currentRow)
              Exit For
          End If
      Next cell
  Set tempRange = Range("A1:A" &amp; currentRow - 1)
  ' Insert a double loop here
  End Sub
  </code></pre>
  
  <p>So, <code>trgtRange</code> is the Variant A and <code>tempRange</code> is Variant B. I know I could have set the Variant B up a little easier, but I already did it that way. After all, code should be polished as last operation anyway.</p>
  
  <p>You might be wondering why Variants A and B are completely the same. Well, that's because I need to compare them so that I can find values that are close to each other, (i.e 10000 and 12000) and I need to incorporate some kind of tolerance for it. </p>