|
-
Dec 3rd, 2009, 11:57 PM
#1
Thread Starter
Member
How to sort a two-dimensional string array?
My array is declared by
Code:
Dim vArray As Object
vArray = oXLSheet.Range("B2:C201").Value
It looks like
1,1
1,2
2,1
2,2
3,1
3,2
.
.
.
199,1
199,2
200,1
200,2
I don't know why it starts at 1 and not 0 but that doesn't concern me.
I would like to sort the array by the second dimension, i.e. using the values in
1,2
2,2
3,2
and so on.
Both dimensions are strings. Obviously the values of 1,1 and 1,2 must stay together.
Can anyone help?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|