gonen
10-03-2013, 09:39 PM
Hi
I am having some trouble to sort by two columns.
The columns are filled with Hebrew characters.
When I sort by one of the columns, sort results are OK
But when I sort by two levels - The sort results are by the first level only, but not by the second level.
Any idea ?
Problem exists when I sort in both ways:
when I sort normally (clicking Data/Sort....) and also when I sort by running VBA macro as:
Rows(First_Student_Row & ":" & Rng_to).Select
Selection.Sort Key1:=Range(Sincol & First_Student_Row), Order1:=xlAscending, Key2:=Range(Name_Col & First_Student_Row) _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _
:=xlSortNormal
Thanbks for your help !!!!
I am having some trouble to sort by two columns.
The columns are filled with Hebrew characters.
When I sort by one of the columns, sort results are OK
But when I sort by two levels - The sort results are by the first level only, but not by the second level.
Any idea ?
Problem exists when I sort in both ways:
when I sort normally (clicking Data/Sort....) and also when I sort by running VBA macro as:
Rows(First_Student_Row & ":" & Rng_to).Select
Selection.Sort Key1:=Range(Sincol & First_Student_Row), Order1:=xlAscending, Key2:=Range(Name_Col & First_Student_Row) _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _
:=xlSortNormal
Thanbks for your help !!!!