title: For Each - Open specified workbooks in array
body: <p>I have about 200ish workbooks That I need opened in a dir containing thousands of files. The name of these 200 files have been placed in <code>Sheet 4 B3:B231</code>.</p>
  
  <p><strong>Whenever I run the macro however, I only get the code to work on 4 of these files, 1 of the 4 isn't even mentioned in the specified range.</strong>  </p>
  
  <pre><code>Dim wb As Workbook, shtDest As Worksheet
  Dim MyFile As String
  Dim Filepath As String
  Dim WoBo As Variant
  Dim DirArray As Variant
  DirArray = Sheets("Sheet4").Range("B3:B231").Value
  
  Filepath = "C:\"
  MyFile = Dir(Filepath)
  
  Set shtDest = ThisWorkbook.Sheets("Sheet1")
  
  For Each WoBo In DirArray
        'code  
  Next WoBo
  End Sub
  </code></pre>
  
  <p>I'm quite new to arrays and I don't really understand the For Each line, so I suspect the error to be there.</p>