title: VBA function to print array result in active cell
body: <p>I'd like to write a <strong>function</strong> where the result should print/write an array into a range of cells.</p>
  
  <p>The active cell should be the first element and the next cell below is the second (and so forth). So if, for example, my current active cell is B2 the desired result should be like in the image below.</p>
  
  <p>My code below works only on the Debug.Pring but I just can't figure it out how to actually have it on the excel sheet. </p>
  
  <pre><code>Function ShowResult()
  
  Dim strArray() As String
  Dim result As String
  result = "Maybe I think too much but something's wrong"
  strArray = Split(result, " ")
  
  Dim StartRow, i As Integer
  StartRow = 1
  
  For i = 0 To UBound(strArray)
      Debug.Print strArray(i)
      'Range("A" &amp; i + StartRow).Value = strArray(i) &lt;--I tried even with this, didn't work!
  Next
  End Function
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/1KXEg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1KXEg.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/8vsWn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8vsWn.png" alt="enter image description here"></a></p>