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?