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