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.