title: VBA autofilling multidimensional arrays
body: <p>As a beginner, I would like to ask if it is possible in VBA to autofill formulas in a multidimensional array.</p>
  
  <p>Ι thought and wrote this code and it works with values but not with formulas.</p>
  
  <p>I think that what I am trying to do is very ambitious for my skills </p>
  
  <pre><code> Sub eucldiist()
       Dim e(10,10) As Double, i As Integer, j As Integer
       For i = 1 To 10
           For j = 1 To 10
               e(i, j).FormulaArray = "=sqrt((offset('Data1'!$Q$14,$BD$5(offset(i)) -
   offset('Data1'!$Q$14,$BD$5(offset(j))^2+ ((offset('Data1'!$U$14, 
   $BD$5(offset(i))-OFFSET('Data1'!$U$14,$BD$5(offset(j)))^2)"
           Next j
       Next i
  
       Sheets("Calculations").Select: Range("A20").Select
  
       For i = 1 To 10
           For j = 1 To 10
               ActiveCell.Value = e(i, j)
               ActiveCell.Offset(0, 1).Select
           Next j
           ActiveCell.Offset(1, -10).Select
       Next i
   End Sub
  </code></pre>
  
  <p>Is it possible what I am trying to do?</p>