Macro does not work

Hello,

I need to copy all the files in the same folder and paste to a combined file.
However, it's always the case that the first files in the folder are not copied fully.
For example, in a folder with 50 files.
File 1 has 2000 lines, and only 500 lines are copied.
File 2 has 3000 lines, and only 300 lines are copied.
...
File 7 has 1000 lines, and only 10 lines are copied.

The rest, from file 8- 50 are okie (although some files not 100% of the lines are copied).

Could you help me to understand why the below code always have problem for the first several files in the folder?

Really appreciate your help!
Chau

=======================================================================================

Please Login or Register  to view this content.

=================================================

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: I have added them for you - this time

Please Login or Register  to view this content.