title: Excel VBA Add Comment from Array
body: <p>I do not understand why the below does not add comments from A1 to A27 :(</p>
  
  <pre><code>Dim aComment As String
  
  aComment = Split("ABC|DEF|GHI|JKL", "|")
  
  For i = 1 To i = 27
      For x = LBound(aComment) To UBound(aComment)
          With Worksheets("report").Range(Cells(1, i)).AddComment
              .Visible = False
              .Text aComment(x)
          End With
      Next
  Next
  </code></pre>
  
  <p>It would be amazing if you could give me a hand, know I am nearly there, but cannot figure out what I got wrong :(</p>