title: get length of each sub array of a array vba
body: <p>I have input array {{1,4}, {1,3}, {1,4,7}}</p>
  
  <pre><code>Dim array1() As Long
  ReDim array1(3, 3)
  array1(1, 1) = 1
  array1(1, 2) = 4
  array1(2, 1) = 1
  array1(2, 2) = 3
  array1(3, 1) = 1
  array1(3, 2) = 4
  array1(3, 3) = 7
  </code></pre>
  
  <p>I would like to have output array (which is length of each subarray) {2,2,3}
  I am thinking to use for loop as following</p>
  
  <pre><code>Dim i As Long
  i = UBound(array1, 1)
  
  Dim outputarray() As Long
  ReDim outputarray(i) As Long
  For j = 1 To i
      outputarray(i) = UBound(array1(i), 2)   'ERROR APPEAR
  Next j
  </code></pre>
  
  <p>i added <code>Option Base 1</code></p>