Sort the list while it's in a worksheet (Excel's native
sort is very fast) and then read it into your array.

Tony
-----Original Message-----
I am trying to enter a list of items in an array. How can
I alphabetize the items (sort them) as they are entered
into the array?
For example, lets say I have a list of names in a
worksheet from cells A1 to A4: Mike, John, Dave, Mark.
As I enter these names into an array, NameArr(), I want
them to be in alphabetical order, so once they are all
entered, NameArr(1) is Dave.
I hope this makes sense.
Thanks.
.