heritagedoorchris
New Member
- Joined
- Jul 6, 2005
- Messages
- 16
I have a very large spreadsheet that I am trying to clean up. There are 240 named ranges in the spreadsheet. Some are used in formulas and some in data validation. I trace dependents to locate those used in formulas. Is there a way find the cells that have data validated using named ranges? It does not show up in a dependent trace. I am using Excel2003. Thank you in advance.