Dean,

it's not as trivial as you might think. The Dependents property in VBA only
gives you dependents on the same sheet. You need to use navigation arrows to
find them across worksheets, then navigate again from the cells you find...
I know you say you don't want to try external tools, but I put a lot of work
into the auditing and tracing routines in my XspandXL add-in and the time
limited trial is fully functional which will get you through your problem.

http://www.enhanceddatasystems.com/E...pandXLHome.htm

Robin Hammond
www.enhanceddatasystems.com

"Dean" wrote in message
...
I have inherited a worksheet that has many rows that are range named. When
I go to a cell in that row and click trace dependents, it shows none, even
though each cell in the row does seem to feed another sheet. Is this the
way it is with range named cells, OR is it only when the range name applies
to multiple cells, OR am I just doing something wrong?

Though I have been told and tried some nice tools created by MVPs, if
possible, I'd like to avoid that, for this aspect, if possible.

Thanks!
Dean