Hi Jay,

You might also want to download Jan Karel Pieterse's Name Manager addin
which will not only handles your list requirement, but almost anything else
that you might wish to do with Excel names:

http://www.jkp-ads.com/Download.htm

---
Regards,
Norman



"Jay" wrote in message
...
How do I create a list of names and have the sheet alphabetize it
automatically?

Thanks