Hi,

Select all the sheet tabs and press Ctrl+F enter #NAME? in the Find what
dialog box set Look in to Values, and then choose Find All. When you do this
Excel will find all the cells which contain range names which were deleted
because formulas using them will return the above error.

If you want to do this for one name at a time enter the name you want to
find like "Data" into the Find what box and set Look in to Formula...


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Michael.Tarnowski" wrote:

Hi Mike,
thanks for your tip. This gives a list of the definitions, but I'am
looking for a kind of list, in which cell of which sheet a name is
*used*. In other words, which cell is effected if a name definition is
deleted.
Michael

Mike H wrote:
hi,

Select a cell where you want the list then

Insert|Names|Paste and paste list

Mike

"Michael.Tarnowski" wrote:

Hi community,
is it possible - and if, how - to get a kind a map i.e. reference,
where defined names are used in a workbook?
Cheers Michael