title: How to create a range from two ranges in VBA?
body: <p>I have two ranges, each containing a single cell (for example "A1" and "C3").</p>
  
  <p>How do I get a new range containing all the cells between these two ("A1:C3")?</p>
  
  <p>I tried this:</p>
  
  <pre><code>Set NewRange = Range(Range1.Address:Range2.Address)
  </code></pre>
  
  <p>Also how do I set a range in R1C1 format? I want to use something like Range("R1C2") instead of Range("A2").    </p>