I have a data list called "AUDITORS" going from cell A1:A3 which is th
RowSource on a Listbox.

Could someone please suggest code that would do the following:

a: Automatically resort the list into alphabetical order prior t
calling it for the Listbox population.

b: Allow me to Add to the List via the listbox and rename as "AUDITORS
if the item name isn't stored on the list.

Note i have used this code to name the range at the moment.

Range("A2").Select
Range(ActiveCell, ActiveCell.End(xlDown)).Select
Selection.Name = "AUDITORS"

Thanks in advance

--
Message posted from http://www.ExcelForum.com