Hey everyone.

Im trying to sort information through one column first then the second column. Eg:

1 2
1 3
2 2
1 1
2 1

should be

1 1
1 2
1 3
2 1
2 2

but its

1 2
1 3
1 1
2 2
2 1

Im using:

Range(Cells(2, 1), Cells(8, 8)).Sort Key1:=Cells(2, 1)

at the moment.

Any help greatly appreciated.