Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort on 3 keys
the division header field is 15,1
dept header field is 16,1 status header field is 17,1 I want this to sort on all 3 in this order. The sort doesn't work thanks, Sub SortDivDept() 'sorts by Divsion, Department & Status Dim Rng As Range Set Rng = Range("A1:Q1") With ActiveSheet Rng.Sort key1:=Cells(15, 1), key2:=Cells(16, 1), key3:=Cells(17, 1), Orientation:=xlSortColumns, MatchCase:=False End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Many Sort Keys | New Users to Excel | |||
Array Sort on 2 keys | Excel Programming | |||
Need to know the Sort Column Keys | Excel Programming | |||
Sort using 4 keys | Excel Programming | |||
Dynamically set Sort keys | Excel Programming |