title: Simple VBA array join not working
body: <p>I'm puzzled why I can't msgbox this joined array. I can do it just fine if I create a static array with typed out values, but with a range of values from excel I keep getting <em>"Invalid Procedure Call or Argument"</em></p>
  
  <p>I've done a fair amount of research but I'm not able to find any examples of this issue. What am I doing wrong here? </p>
  
  <pre><code> Sub From_sheet_make_array()
       Dim myarray() As Variant    
       Dim dudeString As String
  
       myarray() = Range("B2:B10").Value 
       dudeString = Join(myarray(), ", ")
  
       MsgBox dudeString 
   End Sub
  </code></pre>