title: Error in Size array VBA
body: <p>I'm again 
  exist a error when i use array</p>
  
  <p>The maximum size that admits me from the array is 26
  Why is this happening?</p>
  
  <p>the error is in
  Module 3
  function listbox
  in this line</p>
  
  <pre><code>Dim mylist1(26) As String
  For i = 0 To 26
      mylist1(i) = CStr(Worksheets("Helper").Cells(i + 6, 4).Value)
  Next i
  With ws.Range("E8:E8").Validation
      .Delete
      .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
          Operator:=xlBetween, Formula1:=Join(mylist1, ",")
  End With
  </code></pre>
  
  <p>I get values from a hidden sheet
  if change the size to 27 have error after save
  if you change to 27 save
  and open again, has a error</p>
  
  <p>this is file link</p>
  
  <p><a href="https://drive.google.com/open?id=1Uaop86I2AKpeOwORrKYUafGb67b214Bh" rel="nofollow noreferrer">https://drive.google.com/open?id=1Uaop86I2AKpeOwORrKYUafGb67b214Bh</a></p>
  
  <p>thanks</p>