title: How to find overlap values within two ranges
body: <p>I have two ranges. I am trying to find out if there is an overlap in their values. Is there built-in 'application' function that finds if the values within the two ranges overlap? Or do I need to do something like this, where I have two sets of for-loops and some sort of logic that tests if <code>rcellA</code> (cells in range A) overlap with <code>rcellB</code> (cells in range B)? </p>
  
  <pre><code>Set rngA = loopset.range("A2-A999")
  Set rngB = loopset.range("B2-B999")
  For Each rcellA in rngA.cells
  
      For Each rcellB in rngB.cells
  
      Next rcellB
  
  Next rcellA
  </code></pre>