title: Reading array from Excel cells creating 2d array
body: <p>I'm attempting to read a list of cell values in to an Array in Excel VBA.  I am doing this through:</p>
  
  <pre><code>Dim varHrArray As Variant
  varHrArray = Range(Cells(TITLE + 1, HR_LOCATION), Cells(TITLE + intHrLength, HR_LOCATION)).Value
  </code></pre>
  
  <p>While this works, it's creating a 2d array and I am uncertain exactly why.  This has been confirmed by by message boxes, with <code>MsgBox (varHrArray(1, 1))</code> working as expected but <code>MsgBox (varHrArray(1))</code> giving a 'Subscript Out Of Range' error and through directly examining the variable in the watch window - <code>varHrArray</code> is showing as <code>Variant/Variant(1 to 7, 1 to 1)</code> (7 is correct for the length of the list, by the way).</p>
  
  <p>I'm not clear why this is happening or how it can be stopped.</p>