Linking Lines

totobes · May 10th, 2002, 09:01 AM

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 · May 10th, 2002, 09:15 AM

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 · Jun 1st, 2002, 05:08 PM

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

May 10th, 2002, 09:15 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 09:01 AM	#1
totobes New Member Join Date: May 2002 Location: England Posts: 6	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?

Jun 1st, 2002, 05:08 PM	#3
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	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