Jason,
This may help to list all the names:
http://j-walk.com/ss/excel/files/namelist.htm

As for seeing which are referenced, I suppose you have a few option;
- .Find through all formulae on all sheets to see if "RangeName" is used.
- Use something based on Auditing, maybe see if this fails:
Range("RangeName").NavigateArrow(True,1).Select

Obviously neither will tell you if VBA code uses any of the names. You would
have use the VBE and search the code for instances of the name.
http://www.cpearson.com/excel/vbe.htm

NickHK

"TxRaistlin" wrote in message
...
I have an excel 2003 file with multiple sheets, and hndreds of named range
referring to both single cells or ranges. I have renamed some ranges but
the
old names persist. I know I could just delete all of the names in a
workbook
and I have the code for that, but how would i check to see if a range name
is
used anywhere, and if not then delete it?

Appreciate any help as always,

Jason