|
- Dim arr '共有变量,记录原数所表
- Sub 排序() '加辅助列,把所有条件连接起来后放在辅助列
- Dim SortRange As Range
- With Sheet1
- r = .[a65536].End(3).Row
- arr = .Range("a1:i" & r)
- ReDim crr(1 To UBound(arr), 1 To 1)
- For i = 3 To UBound(arr)
- crr(i, 1) = arr(i, 2) & "," & arr(i, 3) & "," & arr(i, 4) & "," & arr(i, 7) & "," & arr(i, 5) & "," & arr(i, 8)
- Next
- .[j1].Resize(r, 1) = crr '加辅助列,把所有条件连接起来后放在辅助列
- .Range("a3:j" & r).Sort key1:=.[j3] '按辅助列排序
- .Columns("j").ClearContents '删除辅助列
- End With
- End Sub
- Sub 取消排序()
- On Error Resume Next
- Sheet1.[a1].Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |
评分
-
查看全部评分
|