title: VBA Display Collection in a message box - error
body: <p>I am trying to Pop-up a message something like, </p>
  
  <pre><code>"There are 3 Reports available . They are Today, Yesterday, Day before"
  </code></pre>
  
  <p>This is the code, </p>
  
  <pre><code>  On Error Resume Next
    For Each a In MonthYear
       arr.Add a, a
    Next
  
    For i = 1 To arr.Count
       Cells(i, 1) = arr(i)
    Next
  
  
  MsgBox ("There are " &amp; arr.Count &amp; " Reports available. They are  " &amp; arr &amp;
  </code></pre>
  
  <p>But it is not working. It says sub or argument not found.</p>