Change dependents on newly named cells

[johan_of_ulm]

Hi,
Trying to change all the references to a certain cell so that instead of "A3" the name appears (some names have been defined after formulas already refer to the newly named cell). The code below is what I have so far (tried many small changes, but always same basic problem). The problem is that instead of going through all the dependents (called "rChild" here), it goes through some of them (sometimes only 1), then goes back to the original cell ("rRoot" here) and stays there (even if I change the condition "rChild.address = last.address" so that it is able runs more iterations, the whole thing is just stuck on the root cell and never sees other dependents).

So here's the code and thanks for the help.

Please Login or Register  to view this content.