I have never learnt IDE so I am looking for some brilliant excelforum user who knows the mysteries of IDE!

I will describe the situation I have and what I want to achieve.

SITUATION:
I have a workbook which has a lot of workbook names (over 200) and a lot of these names are duds (i.e. they are obsolete due to revisions in the project).

OBJECTIVE:
Identify every workbook names that have no references in the VBA code AND have no cell dependents in the worksheets. I can then assume that these names can be deleted safely and proceed to do so manually.

So I need IDE to:
  1. Loop through each name (including hiddens) in the workbooks name manager.
  2. For each name in loop - search code to count number of occurences. If more than one, return TRUE, otherwise if no references found, return FALSE
  3. For each name in loop - search workbook for any cell containing use of this name. If more than one found, return TRUE, else return FALSE
  4. Somehow list the names that have returned FALSE and FALSE to the above two checks - either to worksheet or output as txt file.