title: Reading an Excel Named Range into an Array (VBA)
body: <p>I want to read a named range ('NamedRange') into an array ('NamedRangeAsArray').  I have tried a number of things without success, and am hoping to find a way to do so no matter the length or height of the named range (and by extension then, the dimensions of the array).</p>
  
  <p>I have tried:</p>
  
  <pre><code>Dim NamedRangeAsArray As Variant
  NamedRangeAsArray = Range("NamedRange").Value
  </code></pre>
  
  <p>(only reads the first cell of the named range into the array [1,1]);</p>
  
  <p>also,</p>
  
  <pre><code>NamedRangeAsArray = Range(Workbook.Names("NamedRange").RefersToRange.Address)
  </code></pre>
  
  <p>(does not work at all),</p>
  
  <p>to no avail.  Any ideas?  Please share.  Thanks!</p>
  
  <p><strong>Update:</strong></p>
  
  <pre><code>Dim NamedRangeAsArray() As Variant
  NamedRangeAsArray() = Range(Workbook.Names("NamedRange").RefersToRange.Address)
  For i = LBound(NamedRangeAsArray()) To UBound(NamedRangeAsArray())
      MsgBox NamedRangeAsArray(i, 1)
  Next i
  </code></pre>
  
  <p>(only reads the first cell of the named range into the array [1,1])</p>
  
  <p>Thank you @findwindow and @Brian for your help.</p>