Range.ShowDependents (Excel)
Draws tracer arrows to the direct dependents of the range.
ShowDependents (Remove)
Remove: True to remove one level of tracer arrows to direct dependents. False to expand one level of tracer arrows. The default value is False.
Dim booShowDependents As Boolean
booShowDependents = ActiveCell.ShowDependents