Help Rewriting With Loops

Hello, I wrote some code the other day and I'm excited that it even works. It's just messy without a loop. I tried to read up on loops and I'm a little lost.

Basically, my code adds up each row and then sets each cell to 0. It will add to your total each time you hit the button.

Also, can someone throw in the code on how to 'print' out a variable, so I can see what my loops are doing.

Here is my code:

Please Login or Register  to view this content.

Here are two ALTERNATIVES for loops. My preference is for the second one, but I assume the first one would be more clear for you

Please Login or Register  to view this content.

Please Login or Register  to view this content.

In the second one there are two Debug.Print statements that write to Immediate window and show the result before and after