Help editing this VBA

You don't need to do an additional 'loop' added, you just need to clear your history.
I can run your macro (having amended it).

Anyway - er (in the interests of remaining a team player here), please fix up the post as per Winon and I, (or someone else), can give you the amendment.