|
本帖最后由 -_正在输入 于 2019-10-21 16:15 编辑
- Sub 自定义序列并按行排序2010版()
- y = Sheets("Sheet1").Range("A65536").End(3).Row
- t = Sheets("Sheet1").Range("XFD1").End(xlToLeft).Column 'sheet2 A列最后行
- 'a = ActiveSheet.UsedRange.Address(0, 0)
- Call d2
- With Worksheets("Sheet1")
- With .Sort
- With .SortFields
- .clear
- .Add Key:=Range(Cells(1, 5), Cells(1, t)), SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:=Chr(34) & x & Chr(34), DataOption:=xlSortNormal
-
- End With
- .SetRange Range(Cells(1, 5), Cells(y, t))
- .Orientation = xlLeftToRight
- .Apply
- End With
- End With
- End Sub
复制代码- Sub d2()
- For i = 2 To Sheets("查补排序").Range("A65536").End(3).Row
- x = x & Sheets("查补排序").Cells(i, 1) & ","
- Next i
- x = Left(x, Len(x) - 1)
- End Sub
复制代码
test.rar
(30.9 KB, 下载次数: 3)
|
|