trace all precedents or dependents
 

Hi,

Is there some code I can use to automatically trace all precedents or
dependents of a cell?

I.e., a macro or module which I can assign to a button?

trace all precedents or dependents
 

They're readily available. ViewToolbarsFormula auditing

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" wrote in message ...
| Hi,
|
| Is there some code I can use to automatically trace all precedents or
| dependents of a cell?
|
| I.e., a macro or module which I can assign to a button?

trace all precedents or dependents
 

That method required multiple clicks. I'm interested in code which I can
assign to a button, click once, and have the all of the cell's precedents or
dependents displayed with tracer arrows.

"Niek Otten" wrote:

They're readily available. ViewToolbarsFormula auditing

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" wrote in message ...
| Hi,
|
| Is there some code I can use to automatically trace all precedents or
| dependents of a cell?
|
| I.e., a macro or module which I can assign to a button?

trace all precedents or dependents
 

if they are on the same sheet, look at the

directPrecedents
directDependents
Precedents
Dependents
properties of the range class.

If they are off sheet or links, then it gets much much harder.

--
Regards,
Tom Ogilvy


"Dave F" wrote:

Hi,

Is there some code I can use to automatically trace all precedents or
dependents of a cell?

I.e., a macro or module which I can assign to a button?

trace all precedents or dependents
 

Thanks, Tom. For now I'm just thinking of precedents and dependents on the
same sheet...

"Tom Ogilvy" wrote:

if they are on the same sheet, look at the

directPrecedents
directDependents
Precedents
Dependents
properties of the range class.

If they are off sheet or links, then it gets much much harder.

--
Regards,
Tom Ogilvy


"Dave F" wrote:

Hi,

Is there some code I can use to automatically trace all precedents or
dependents of a cell?

I.e., a macro or module which I can assign to a button?

trace all precedents or dependents
 

My previous post doesn't show the arrows. To do that the easiest way to get
the code is to:
Turn on the macro recorder (tools menu - macro - record a new macro) while
you do it manually. Turn off the macro recorder. Then modify the recorded
code to achieve those same results.

--
Regards,
Tom Ogilvy


"Dave F" wrote:

That method required multiple clicks. I'm interested in code which I can
assign to a button, click once, and have the all of the cell's precedents or
dependents displayed with tracer arrows.

"Niek Otten" wrote:

They're readily available. ViewToolbarsFormula auditing

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" wrote in message ...
| Hi,
|
| Is there some code I can use to automatically trace all precedents or
| dependents of a cell?
|
| I.e., a macro or module which I can assign to a button?

trace all precedents or dependents
 

Dave,
There is the
ActiveCell.ShowDependents False
which adds the next level of dependents' arrow each time you call it.
I don't see an easy way to know when you have reached the end though.

NickHK

"Dave F" wrote in message
...
Hi,

Is there some code I can use to automatically trace all precedents or
dependents of a cell?

I.e., a macro or module which I can assign to a button?