Again, I'll apologize as not a coder, I am fixing code I was provided. I
checked and checked and determined somehow that the VBA is WORKING as are my
formulas but somehow it works sometimes and sometimes not. Does anyone have
any idea what could be happening here?

Basically I a have column called €˜Levels that determines parenting and
those Levels are derived by an Indenture Formula.

So I have

Level | Name

Which ends up parsing as

Name | Parent

0Main
1Sub1
1Sub2
2Sub2A
2Sub2B
3Sub2BA
3Sub2BB
2Sub2B

Sub 1 | Main
Sub 2 | Main
Sub2A | Sub2

etc

I was running into errors on the parsing because when it stepped back up
(in this case to Sub2B) it got the wrong parent.

I thought something was wrong with the code that parsed the Level/Name

On a lark I recreated the same data beneath itself but this time I pasted
the Level Values in as Values rather then formulas.

Now the Parent Level Worked.

So I figured ok it is having trouble parsing the code and the formula.

So as a final test I copied the data a third time beneath the non-working
group (with formulas) and the working group (w/o formulas) but pasted
normally, i.e. kept the formulas.

And lo and behold the first group still parsed WRONG, the group with the
fixed values parsed correctly, but the third group with the EXACT same values
AND with the formulas ALSO worked fine.

So Ive determined that:

The VBA works fine

The Formulas are not a problem

So how could this work sometimes but not others when the values are exactly
the same?

The only difference between the first and last group is the rows they start
on otherwise 100% identical.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions