.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
ActiveWindow.SmallScroll Down:=-51
您好,能解读下每句话的意思吗?我是新手。。什么都不懂
With ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort 'Sheet1中选择:数据-->排序
.Header = xlYes '首行为列标题:是
.MatchCase = False '区分大小写:否
.Orientation = xlTopToBottom '方向:从上到小
.SortMethod = xlPinYin '筛选顺序:按拼音
.Apply '确定
End With '结束