Range.ShowPrecedents (Excel)

Draws tracer arrows to the direct precedents of the range.

ShowPrecedents (Remove)

Remove: True to remove one level of tracer arrows to direct precedents. False to expand one level of tracer arrows. The default value is False.

Dim booShowPrecedents As Boolean
booShowPrecedents = ActiveCell.ShowPrecedents