title: How to set and use empty range in VBA?
body: <p>I would like to use empty range in following manner :</p>
  
  <p><code>Set NewRange = Union(EmptyRange, SomeRange)</code></p>
  
  <p>I've tried to set <code>EmptyRange</code> as empty range using <code>Nothing</code>, <code>Empty</code> and <code>Null</code> but  <em>"run-time error '5'  Invalid procedure call or argument"</em> occurs, it seems that I have to use <code>If</code> statement or  there is other keyword which do the job ?               </p>
  
  <p>I can use :</p>
  
  <pre><code>If EmptyRange Is Nothing Then
     Set NewRange = SomeRange
  Else
     Set NewRange = Union(EmptyRange, SomeRange)
  End If
  </code></pre>
  
  <p>instead of construction:</p>
  
  <pre><code>Set NewRange = Union(EmptyRange, SomeRange)
  </code></pre>