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

jplank

Board Regular
Joined
Sep 19, 2012
Messages
59
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

Well-known Member
Joined
Dec 5, 2002
Messages
7,555
Office Version
2016
Platform
Windows
As fa as I can tell , not unless you iterate all the cells with data validation and\or the userform listboxes.
 

Forum statistics

Threads
1,084,819
Messages
5,380,090
Members
401,645
Latest member
Me22

Some videos you may like

This Week's Hot Topics

Top