erase an array resulting in array not populated when the macro runs again

I have a two dimentional array that's redim preserved:

Please Login or Register  to view this content.

If I don't have "erase ar()" line then if I run a few times (consecutively) then I get the same array stacked multiple times. If I have that line then I don't get any results (if I run multiple times - the first time is OK)

If I don't run it consecutively then there's no issue. Just wondering why and if it's OK to run multiple times(in case client does it even there's no reason to run multiple times). Any insight is appreciated!

For a static array, the erase function will empty the data elements but leave the elements with empty values.
For a dynamic array, the erase function destroys the array and the empties the memory, requiring a complete rebuild of the array to restore the elements. Since your erase statement is outside the Do loop that builds the array and after the statement that applies the array value, I don't see how it would affect what the array produces. But if it the code posted is actually inside another loop and not shown for this post, then the the behavior could be the result of how the erase function is treating your array.

Perhaps if you explained what you are trying to do, we could offer an alternative solution without using the erase fuction.

I found the issue. I didn't set the x=0 before the loop ( I thought I did in the real code) and that's why it kept adding up. It was driving me bunkers! Thank you for replying!

Thanks for the feedback,
regards, JLG