Evaluate("SUM

**PcMax** · 09-10-2012, 04:00 PM

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

**Rick Rothstein** · 09-10-2012, 09:52 PM

Originally Posted by PcMax

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

Nevermind... I had misunderstood your intent when I first read your added code line... I see what you are doing now. I am glad everything is working for you now.