- Sub 按钮1_Click()
- Dim arr, brr(), x%, y%, i%, j%, k
- arr = Range("A2:A" & Range("A65536").End(xlUp).Row)
- ReDim brr(0 To UBound(arr), 1 To 1)
- For x = 1 To UBound(arr) - 1
- For y = x + 1 To UBound(arr)
- If arr(x, 1) > arr(y, 1) Then
- k = arr(x, 1)
- arr(x, 1) = arr(y, 1)
- arr(y, 1) = k
- End If
- Next y
- i = i + 1
- ReDim Preserve brr(0 To UBound(arr), 1 To i)
- brr(0, i) = "第" & i & "次"
- For j = 1 To UBound(arr)
- brr(j, i) = arr(j, 1)
- Next j
- Next x
- Range("B1").Resize(UBound(brr) + 1, i) = brr
- End Sub
复制代码 |