Excel vba - Closing part of code in a loop

Please do not link to untrusted third-party web sites for content. Paste your code directly into your post here.

When pasting code, use code tags. There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]


Why use code tags? Code tags:

1. Are required by rules (see rule #2)
2. Preserve spacing used to show code structure (otherwise leading spaces and repeated spaces are removed)
3. Add scroll bars to navigate code with long lines or a lot of lines