JohnLynam1
New Member
- Joined
- Jan 16, 2025
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
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
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