Referencing a counting variable within a recursive procedure

[bvwalker1]

If I have a subroutine that is recursive and I want to keep track of the number of values found as it recursively calls itself, how can I do that? The counter resets after each recursive call.

[AlphaFrog]

Declare the variable at the top of the code module so it is persistent

[shg]

You could recode as a function and make it the return value, For example,

Please Login or Register  to view this content.

	A	B	C
1	XFD	16384	B1: =colnum(A1)

[bvwalker1]

Declare the variable at the top of the code module so it is persistent

AlphaFrog - This works first time through, but if I run it again, it seems to add on to previous value. I must need to set the variable back to zero somewhere?

[bvwalker1]

Here is the code I am running. It does the calculation correctly, but I want to store each solution in an array. I'm trying to store each solution in an array so I need to keep track of and increment array index as solutions are found. Since I declared the index variable as global, the variable needs to be reset to zero once the process has completed so the count is accurate next time it initiates. Once I have the solutions stored in the array, I will make the sub into a function that returns this array. On further inspection, it appears that maybe the problem is the program is still running even though it has finished. If I actually end it myself then re-run it, it works. But if I don't manually end it, it crashes because it continues on with the index count from the previous run.

Please Login or Register  to view this content.

[bvwalker1]

You could recode as a function and make it the return value, For example,

Please Login or Register  to view this content.

	A	B	C
1	XFD	16384	B1: =colnum(A1)

shg - I'm not sure I follow what you are doing.

[shg]

Here's a pretty terrible way to subtract two numbers using recursion by modifying an argument:

Please Login or Register  to view this content.

[shg]

Here's the same thing using the return value of the function:

Please Login or Register  to view this content.

[bvwalker1]

I figured it out. I used static variables and preserve keyword.

Please Login or Register  to view this content.