Sort a VBA array by multiple columns

[JohnLynam1]

Hi all,

I am trying to sort an array with multiple columns (called OutputArray1), first by its first column values and then by its second column values and then by its 5th column values and store the new array as outputArray2 . I am aware of the function below, but I can't seem to extend it to sort by multiple columns. Is there a way to do this?

OutputArray2 = WorksheetFunction.Sort(OutputArray1, 1, 1, False).

Thanks for any help. Cheers

 

[Alex Blakenburg]

Try this:

OutputArray2 = WorksheetFunction.Sort(OutputArray1, Array(1, 2, 5), Array(1, 1, 1), False)

Note: you can put it back into the same array variable if you don't want to create a 2nd variable ie have OutputArray1 = ...

 

[JohnLynam1]

Alex, that works perfectly. Thank you so much. It would never have occurred to me to try that syntax.

 

[Alex Blakenburg]

You're welcome. Glad I could help.

PS: In the worsheet the 2 arrays would just be in curly brackets {}