Sub Tri_Ascendant()
With ActiveSheet
derlig = .Range("e" & Rows.Count).End(xlUp).Row
For i = 2 To derlig
.Range("e" & i).Sort Key1:=.Cells(2, 5), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal, DataOption1:=xlSortTextAsNumbers
Next i
End With
End Sub