Excel VBA Recursion

Recurse a list of parent/children and calculate the longest cumulative length for the initial parent. Input is the initial parent, and the data is in three fields - parent, child and length. ## Deliverables For a Parent (root parent) on Sheets("PARENTS"), I need to recurse Sheets("LENGTHS") and get the longest cumulative length from root parent to ending branch. For example, root parent 2501 has 5 possible paths. Cumulative lengths and last child are listed below. Child - Cumulative Distance 190201 - 375 2006600 - 775 2007404 - 775 43229 - 655 43249 - 924 The program would identify 924 as the Max Cumulative Length and return it to Sheets("PARENTS") in cell B2. Thanks!