Linking Lines

[totobes]

I want to draw linking arrows between cells that relate to each other, but I don't want to pick and place an arrow for each individual cell.

Is there a way to click on one cell, and then on another to create the link, with the same properties for each line?

 

[Mark O'Brien]

How about, CTRL+ "a" to seelct all, go to Tools|Auditing|Trace Dependents to give you a lovely blue arrow connection each cell that is dependent upon it.

It's not pretty, but it might be what you're looking for.

HTH

 

[Corni]

If your working area is bigger and with many dependents, you can use this procedure:

Dim c As Range
For Each c In ActiveSheet.UsedRange
c.Select
Selection.ShowDependents
Next c