PDA

View Full Version : Help on this formula



jumbel
11-25-2008, 03:19 AM
I need to modify a program written by some other person. Can anybody explain what the following formula does exactly???


Selection.Sort Key1:=Range("A8"), Order1:=xlAscending, Key2:=Range("A13") _^
, Order2:=xlAscending, Key3:=Range("A6"), Order3:=xlAscending,Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight,_
DataOption1:=xlSortNormal, DataOption2:=xlSortTextAsNumbers, DataOption3:= _
xlSortNormal

Thanks

GTO
11-25-2008, 03:36 AM
I need to modify a program written by some other person. Can anybody explain what the following formula does exactly???


Selection.Sort Key1:=Range("A8"), Order1:=xlAscending, Key2:=Range("A13") _^
, Order2:=xlAscending, Key3:=Range("A6"), Order3:=xlAscending,Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight,_
DataOption1:=xlSortNormal, DataOption2:=xlSortTextAsNumbers, DataOption3:= _
xlSortNormal

Thanks

Hi Jumbel:) ,

It's sorting a pre-selected (selection) area of cells, using A8 as the primary key. Its a "sideways" sort, that is, "on-end" from a "normal" sort.

In case you cannot (company or private info) show us the "exact" sheet, could you post an example sheet with fake data?

Mark

PS - I didn't pick up some of the optional, so if this is in 2007, could you SvaeAs 2003?

Also- I don't think the caret belongs...