Hi,
First of all, thank you all for the hints. I think I oversimplified my
problem when I asked for help.
In fact, I have a hierarchy in excel that looks like this
A B
C D
E
F
G H I
I have a hard time creating a sub that recognizes the relative position
of each member(child) in the structure. Ideally, each element should
state the descendency( in lack of a better word)in the tree. For
instance, each cell in my range (D for instance) should recognize that
it's 1_2_1 and H that it's 2_1. It's really like a tree..
One more precision, the elements are not related in any way other that
their relative position in the hierarchy.
Someone care to help
Gabriel
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!