Here is a screenshot of what I'm trying to do http://i.stack.imgur.com/7guvr.png
And here is my excel https://drive.google.com/file/d/0B1G...it?usp=sharing
The loop checks if the part level indicates it is a parent assembly (the level is lower than the one beneath). Then it sums all the child parts/assemblies Unit Weights below it ( a child part has no other parts beneath it). I'm getting an "out of range error" and i'm not sure why or if this is the best approach.
Please Login or Register to view this content.