Quote Originally Posted by mikerickson
How big an array is this?
Pasting it onto a worksheet and using Excel's Sort may be the easiest/quickest way to both sort and eliminate blank rows. RowSource can then be used to display things in the ListBox.
But as he said earlier, it is Word app not Excel, hence using a range is not necessarily viable.