筛选

Selection.AutoFilter
ActiveWorkbook.Worksheets("基础数据").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("基础数据").Range("A2:I2").Select
Selection.AutoFilter
ActiveWorkbook.Worksheets("基础数据").AutoFilter.Sort.SortFields.Add Key:=Range( _
"I2:I" & lnu2), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal

With ActiveWorkbook.Worksheets("基础数据").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply