Hi there,
I have the below VBA that is supposed to do a sort. No error when I run it but no sorting either and I'm sorting normal figures(1, 2, 3)
Sub ECB_Sort()
Dim Sortrange As Range
With Sheets("ECB")
Set Sortrange = .Range("A2:AB2100")
Sortrange.Sort Key1:=.Range("L1"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End With
End Sub
I have the below VBA that is supposed to do a sort. No error when I run it but no sorting either and I'm sorting normal figures(1, 2, 3)
Sub ECB_Sort()
Dim Sortrange As Range
With Sheets("ECB")
Set Sortrange = .Range("A2:AB2100")
Sortrange.Sort Key1:=.Range("L1"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End With
End Sub