Merhabalar,
Gönderdiğiniz dosyaya göre bu kodları kullanabilirsiniz..
Sub ExcelTurkey()
Dim i&
For i = 1 To Cells(Rows.Count, "A").End(3).Row
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Add2 _
Key:=Range("A" & i & ":L" & i), SortOn:=0, Order:=1, DataOption:=0
With ActiveWorkbook.Worksheets("Sheet2").Sort
.SetRange Range("A" & i & ":L" & i)
.Header = xlGuess
.MatchCase = False
.Orientation = xlLeftToRight
.SortMethod = xlPinYin
.Apply
End With
Next i
MsgBox "İşlem Tamamlandı.", vbInformation, "Www.ExcelTurkey.Com"
i = Empty
End Sub