Can you sort the original range?

If not, John Walkenbach has a way:
http://j-walk.com/ss/excel/tips/tip47.htm

In fact, his sample code fills a listbox with unique entries with an optional
sort.

keith wrote:

Hello,
Is there a method somewhere in the listbox object that
will allow me to sort the entire listbox based on a column
reference? If it is there I can't seem to find it.
thank you,
Keith

--

Dave Peterson