title: Why array Index starts at 1 when passing range values to array
body: <p>In this VBA program all I am trying to do is to pass an array from spreadsheet and add 1 to each of the array's cells. My problem is with the index of the array. when I start looping the array it doesnt 
  work when I start the index from zero ( I get error subscript out of range) but it works perfectly when I start the array from 1. Why is that? (I thought that would be the case only I specify at the top <em>Option Base 1</em>)</p>
  
  <pre><code>Sub Passarray()
      Dim Array As Variant
      Dim i, j As Integer
      'Pass array and manipulate
      Vol = Range("Volatility")
      For i = 0 To 2
         For j = 0 To 2
            Vol(i, j) = 1+ Vol(i,j)
         Next j
      Next i
  End Sub
  </code></pre>