title: VBA for Excel - How to check intersection of ranges are not empty
body: <p>I have two questions:
  1) How do I check if  the intersection or a range is not empty? For example if I want to check if its empty I write for example</p>
  
  <pre><code>if application.intersect(r1,r2) is nothing
  </code></pre>
  
  <p>but is there something that is negation of nothing? not nothing didn't work for example.</p>
  
  <p>2) How can I compate ranges? For example I have ranges r1,r2,r3 and I want to check if the intersection of r1 and r2 is r3. Two thing that I have tried and didn't work:</p>
  
  <pre><code>1 - application.intersect(r1,r2) = r3
  2 - application.intersect(r1,r2) is r3
  </code></pre>
  
  <p>Would appreciate any help that I can get, Thanks!</p>