Basic loop question

Hello,

I'm new here and new to VBA/Programming in general, so forgive me if this question is stupid.....

Basically, I need some advice on how to write the code below with a loop? It does exactly what I need it to do as it is, but it looks clumsy I guess and I'd like to get a basic understanding of loops etc. I've googled a few examples but so far they've flew over my head... I think with something related to what I'm doing will help me understand the terms/theory etc. better.

Thanks in advance for any help

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any Time Jim..