My loop is missing last iteration

Originally Posted by YasserKhalil

Just try to remove that line

mws.Range("h1") = mRng

You have made it totally correct @YasserKhalil

there is another issue.

The issue is which order the loop read the files. cause the macro write over current values.

Why I thought your version of the macro is was missing values but actually my bad.




MFU7Quv.png


The macro ads First Test1.xlsx the values 30 and 40 then it adds test2.xlsx all cells even if they are empty.
So I need to create an criteria to the loop that asks" If Same Row Column "I" is empty skip the cell if not add

Do you see what I mean Master?

Thank you in advance.