Is there anyway to reference a value in a nested subassembly's workbook in the parent's Local? I know you could set up a variable at a higher level that both could see, but I'm looking to get a value that's been calculated, without copying and mangling the formula.