Thread: Sorting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Sorting

Two sorts are required. Sort first by Key #4 (T2). Then sort a 2nd time with 3
keys, #1 = N2, #2 = A2, #3 = S2

On Tue, 25 Jan 2005 18:37:31 -0800, "Patrick Simonds"
wrote:

Any one know of a way to sort by 4 key's

Key1:=Range("N2"), Order1:=xlAscending,

Key2:=Range("A2"), Order2:=xlAscending,

Key3:=Range("S2"), Order3:=xlAscending,

Key4:=Range("T2"), Order4:=xlAscending,