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?

They're readily available. View>Toolbars>Formula auditing

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" <[email protected]> wrote in message news:[email protected]...
| 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?

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. View>Toolbars>Formula auditing
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Dave F" <[email protected]> wrote in message news:[email protected]...
> | 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?
>
>
>

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?

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?

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. View>Toolbars>Formula auditing
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> > Microsoft MVP - Excel
> >
> > "Dave F" <[email protected]> wrote in message news:[email protected]...
> > | 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?
> >
> >
> >

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" <[email protected]> wrote in message
news:[email protected]...
> 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?