Some typical resullts using the coding from the last post

Consider this test input range

_____ ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
1
2
 c WasB2
3
 AB WasB3
4
 Aa WasB4
5
 A WasB5
6
 C WasB6
7
6
 WasB7
8
32
 WasB8
9
 bcde WasB9
10
Worksheet: Sorting




After running Sub TestieSimpleArraySort5() , you should see this:

_____ ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
1
2
 c WasB2
6
 WasB7 C WasB6
3
 AB WasB3
32
 WasB8 c WasB2
4
 Aa WasB4 A WasB5 bcde WasB9
5
 A WasB5 Aa WasB4 AB WasB3
6
 C WasB6 AB WasB3 Aa WasB4
7
6
 WasB7 bcde WasB9 A WasB5
8
32
 WasB8 C WasB6
32
 WasB8
9
 bcde WasB9 c WasB2
6
 WasB7
10
Worksheet: Sorting