Reading an Excel Named Range into an Array (VBA)
<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>