title: VBA Put the array into the specified cell
body: <p>I have an array obtained from xpath, I want to put it from C~**, because the number of items in the array is different, the following is the solution I wrote, but he can't execute</p>
  <pre><code>Sub main2()
  Dim myURL As String
  myURL = &quot;https://exsample.com&quot;
  
  Set xmlDoc = CreateObject(&quot;Microsoft.XMLDOM&quot;)
  xmlDoc.SetProperty &quot;SelectionLanguage&quot;, &quot;XPath&quot;
  xmlDoc.async = False
  
  With CreateObject(&quot;MSXML2.XMLHTTP&quot;)
      .Open &quot;GET&quot;, myURL, False
      .send
      xmlDoc.LoadXML .responseText
  End With
  
  Set nodeXML = xmlDoc.getElementsByTagName(&quot;Business_Item_Desc&quot;)
  For i = 0 To nodeXML.Length - 1
      Sheet4.Range(&quot;C1:Z1&quot;).Value = nodeXML
  Next
  
  End Sub
  </code></pre>