I just discovered that Trace Dependents doesn't find ranges that use Offset() in their definition.
When I Trace Dependents on $A$3, it does not point to myRange ($C$13:$C$20).Please Login or Register to view this content.
It seems to me that since $A$3 is specifically used in the Defined Range Name, that it should be found.
Is there any way to find ranges that are dependent on $A$3?
Bookmarks