- Sub main()
- Dim arr, brr, n%, n1%, m%
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- Range("i1").CurrentRegion.ClearContents
- For n = 1 To UBound(arr)
- If arr(n, 4) <> "" Then
- For m = 1 To UBound(arr, 2)
- brr(n1 + 1, m) = arr(n, m)
- Next
- n1 = n1 + 1
- End If
- Next
- Range("i1").Resize(UBound(brr), UBound(brr, 2)) = brr
- Range("i1").CurrentRegion.Sort Range("m1"), xlAscending, , , , , , xlYes
- End Sub
复制代码 |