def rangename3d(book, ref3d):
 coords = ref3d.coords
 return ('%s!%s' % (sheetrange(book, *coords[:2]), rangename2d(*coords[2:6])))

def rangename3d ( book , ref3d ) : coords = ref3d . coords return ( '%s!%s' % ( sheetrange ( book , * coords [ : 2 ] ) , rangename2d ( * coords [ 2 : 6 ] ) ) )
utility function: ref3d => sheet2:sheet3!$h$6:$j$20 .