|
- Sub test()
- Dim arr, i&, j%, t&, tmp(1)
- Application.EnableEvents = False
- On Error Resume Next
- arr = Application.InputBox("请选择需要排序的区域", "提示", "$B$6:$B$25", , , , , 8).Value
- If Err.Number > 0 Then MsgBox "请选择一个有效的数据区域": Exit Sub
- For i = 1 To UBound(arr) Step 2
- For t = i + 2 To UBound(arr)
- If arr(t, 1) > arr(i, 1) Then
- tmp(0) = arr(i, 1)
- tmp(1) = arr(i + 1, 1)
- arr(i, 1) = arr(t, 1)
- arr(i + 1, 1) = arr(t + 1, 1)
- arr(t, 1) = tmp(0)
- arr(t + 1, 1) = tmp(1)
- End If
- Next
- Next
- Application.InputBox("请选择排序后导出区域", "提示", "$G$6", , , , , 8).Resize(UBound(arr)) = arr
- If Err.Number > 0 Then MsgBox "请选择一个有效的数据区域": Exit Sub
- Application.EnableEvents = True
- End Sub
复制代码 |
|