Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub SapXep()
- 'Bien dong cuoi
- Dim lr As Long
- lr = Worksheets("Data").Cells(Rows.Count, 1).End(xlUp).Row
- 'Dieu kien chi sap xep khi bang tinh co du lieu
- If lr > 1 Then 'Dong tieu de la dong 1
- 'Xoa cac noi dung sap xep truoc do
- ActiveWorkbook.Worksheets("Data").Sort.SortFields.Clear
- 'Sap xep
- ActiveWorkbook.Worksheets("Data").Sort.SortFields.Add2 Key:=Range("A2:A" & lr), _
- SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
- With ActiveWorkbook.Worksheets("Data").Sort
- .SetRange Range("A1:E" & lr)
- .Header = xlYes
- .MatchCase = False
- .Orientation = xlTopToBottom
- .SortMethod = xlPinYin
- .Apply
- End With
- End If
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement