Hi,

If I understand the purpose of that last line (highlighted in red) correctly, shouldn't it appear at the top of the code rather than the bottom? Located at the bottom, there are circumstances when it would clear values that were just placed, right?
In my tests I'm not deleting data you just entered, to be sure the rule is to place the first cycle:
Code:
Cells(1, 15).Resize(MediaL2).ClearContents
Thank you for the valuable suggestions