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.