Is there a way to clear all variables after a loop?

I'm using a block of code that was written by someone else to perform some calculations.
This is a list of the variables created by the original authors of the program.

Please Login or Register  to view this content.

Because I ported this code into my spreadsheet, I suspect that there's some way that these get reset each time the code is run. Somehow, that 'reset' isn't working.
Is there a way to clear all variables after each iteration?

Thanks,
-gshock

You need to post the code, remember to use Code Tags

Those variables must have a value set within the code. This will overwrite any previous values. The variables will be cleared from memory when the workbook is closed.

To start tidying up. all constants & variables need to be at the top of the macro, before the actual code.

This line makes no sense

Please Login or Register  to view this content.

It needn't be a loop because 2 to 2 would be 1.

Originally Posted by royUK

To start tidying up. all constants & variables need to be at the top of the macro, before the actual code.

This line makes no sense

Please Login or Register  to view this content.

It needn't be a loop because 2 to 2 would be 1.

I'm just doing that to get it to run through once to see if I can find where it's causing the error. I have also tried running it through 4 loops using

Please Login or Register  to view this content.

If you notice the comment on that line, the code should loop through all the columns that have data based on the values in row 9. rylo helped me with the loop. Thanks for taking the time to look at this.

Regards,