Solved: Sort data in a listbox

[lynnnow]

The array has 200 rows and 4 columns with the fields being Last Name, First Name, Phone No., and Email ID or other info (not exceeding 25 chars).

I read the RowSource help, however, how will you predetermine the size of an array? Will ReDim work?

I tried ReDim, but my array is a static array, so I can't ReDim it. Also tried using the MyList1(100 to 200, 1 to 4) syntax in the Public statement, but it doesn't work.