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?