title: VBA using .Formula in Excel returns 0 when the Range.Value is Empty
body: <p>if the result of the <code>.Formula = "='C:\data\[adxl364.xls]ADXL364_QC'!A1"</code> is empty, it returns a value of <code>0</code> in my <code>Worksheet</code>.</p>
  
  <p>what should I add to the code for it not to return a value of <code>0</code> when the <code>Cell</code> is empty?</p>
  
  <pre><code>Sub GetRange()
      With Range("A:Z")
          .Formula = "='C:\data\[adxl364.xls]ADXL364_QC'!A1"
          .Formula = .Value
      End With
  End Sub
  </code></pre>