Where will this sub go, before pushing the data to the array or after pushing the data to the array? I'm a bit lost on how to refer my array viz. myList1(x, y).

Also, my array has 200 rows and 4 columns, but I need it to be sorted on the first column, i.e., last name.

Now while using this code, I realized that this is not an Excel problem, it is a Word query. Can this post be moved there?