Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Anonymous
in reply to: JhoelForshav

This worked perfectly! Exactly what I was looking for.

 

I tweaked this code a little such that it will search for the mainPartlist through each sheet and since my mainpartlist will have atleast more than 2 rows I provided that If oRowMain >2 Then statement.

 

Thank you for this solution. But I do have one question with this line below.

For Each oBOMrow As DrawingBOMRow In oRow.ReferencedRows

This means that it is trying to find that item in Partlist row in the BOM with common reference document? And from that it is grabbing the component definition? What this definition would be? Please elaborate if you can!