title: VBA unable to read other workbooks from same folder
body: <p>This is with reference to my previous questions that has been solved but come out another problems: <a href="https://stackoverflow.com/questions/57396560/vba-unable-to-read-files-after-closing-and-reopen-excel/57397696#57397696">VBA unable to read files after closing and reopen excel</a></p>
  
  <p>All 3 files are in same folder and are opened. It giving me Run time error 9: Subscript out of range. </p>
  
  <pre><code>For i = 1 To rows 
  Workbooks(destination).Worksheets(destinationSheet).Cells( destinationSheetRow + i, Cells(8, j + 3)) = Workbooks(source).Worksheets(sourceSheet).Cells(sourceSheetRow + i, Cells(4, j + 3))
  Next i
  </code></pre>
  
  <p>When I did debugging, both destination and source are the full path and sheet name are correct. Not sure what the problems. Thanks</p>