title: VBA convert range to array and format date
body: <p>I am struggling with a conversion to array in VBA :</p>
  
  <pre><code>Dim list As Range
  Set list = Range(series, series.End(xlDown))
  list.Select
  Dim table() As Variant
  Set table = list.value
  </code></pre>
  
  <p>My understanding is that <code>value</code> returns an array right ? I don't get why VBA tells me that I <code>"can't assign to array"</code>.</p>
  
  <p>My <code>list</code> range looks like that in Excel at the <code>Select</code>, and i aim at having that as an array so that I can format my dates using something like <code>Format(table.Rows(i).Columns(1).value, "yyyy-mm-dd")</code>, looping on my table.</p>
  
  <pre><code>02-Sep-09   1.00
  18-Sep-09   1.00
  16-Oct-09   1.00
  20-Nov-09   1.00
  18-Dec-09   1.00
  19-Mar-10   1.00
  18-Jun-10   1.00
  </code></pre>
  
  <p>By the way, is it possible to modify the table in place ?</p>
  
  <p>Thanks !</p>