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.