Hi all, I have a question when using sorting function in VBA.
I have a table which have around 30 rows.
I would like to sort the date of 10 rows within the table (say row 11-20 only) and do not want to affect other rows.
I created the following commend in VBA but fail to do so.
Sub Test()
With ActiveSheet.Sort.SortFields
.Clear
.Add Columns(3), Order:=xlAscending
.Add Columns(2), Order:=xlDescending
.Add Columns(1), Order:=xlAscending
End With
With ActiveSheet.Sort
.SetRange ActiveCell
.Header = xlNo
.MatchCase = False
.Apply
End With
End Sub
I selected rows 11-20 but it sorted the whole table.
How can I fix it?
Thank you
Kin
Bookmarks