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

jplank

New Member
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.
 

Some videos you may like

This Week's Hot Topics

Top