title: Arrays of unknown length in Visual Basic
body: <p>I have a piece of code written in Visual Basic:</p>
  
  <pre><code>Dim n As Double, i As Integer
  n = 4
  Dim Ramp_length(1 To 4) As Double
  For i = 1 To n
      Ramp_length(i) = Cells(13 + i, 5)
      'Cells(65 + i, 7) = Ramp_length(i)'
  Next i
  </code></pre>
  
  <p>Is there a way I can reproduce the result without declaring the array with a "fixed" length? I eventually want the code to read off a column of data with unknown length and store it in an array of equal or smaller length so it can be altered. This is just a piece of the code...if someone could help me out that would be great! :D</p>
  
  <p>Thanks</p>