How to find where a named range is being used for data validation or as a rowsource?

[jplank]

I have a named range in a large spreadsheet that I suspect is being used for either a) data validation for some cell or b) as a rowsource for some combobox on a userform. Is there a "simple" way to find out where exactly it's being used? My understanding is that trace dependents will only check if the named range is used as part of a formula.

 

[Jaafar Tribak]

As fa as I can tell , not unless you iterate all the cells with data validation and\or the userform listboxes.