title: How to check whether a variant array is unallocated?
body: <pre><code>   Dim Result() As Variant
  </code></pre>
  
  <p>In my watch window, this appears as </p>
  
  <pre><code>Expression | Value | Type
  Result     |       | Variant/Variant()
  </code></pre>
  
  <p>How do I check the following:</p>
  
  <pre><code>   if Result is nothing then
  </code></pre>
  
  <p>or</p>
  
  <pre><code>   if Result is Not Set then
  </code></pre>
  
  <p>This is basically what I am trying to accomplish, but the first one does not work and the second does not exist.</p>