Hi,
Please help me with Error 424 in following: -
Dim RangeEAs Range
LastRow = 35
Range("AA1").Select
Selection.AutoFilter
Set RangeE= Nothing
Set RangeE= Worksheets(1).Range("AB1", "AB" & LastRow)
Cells.Select
Selection.AutoFilter
Selection.AutoFilter.Sort.SortFields.Clear
Selection.AutoFilter.Sort.SortFields.Add Key:=RangeE, SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets(1).AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Selection.AutoFilter
Bookmarks