|
- Sub 冒泡排序_大到小()
- Dim arr, i As Integer, j As Integer, temp
- arr = Sheet1.Range("a2:a26")
- For i = 1 To UBound(arr) - 1
- temp = arr(i, 1)
- For j = i + 1 To UBound(arr)
- If temp < arr(j, 1) Then
- temp = arr(j, 1) 'temp装最大值
- arr(j, 1) = arr(i, 1)
- arr(i, 1) = temp
- End If
- Next
- Next
- Sheet1.Range("B2:B26") = arr
- End Sub
- Sub 冒泡排序_小到大()
- Dim arr, i As Integer, j As Integer, temp
- arr = Sheet1.Range("a2:a26")
- For i = 1 To UBound(arr) - 1
- temp = arr(i, 1)
- For j = i + 1 To UBound(arr)
- If temp > arr(j, 1) Then
- temp = arr(j, 1) 'temp装最小值
- arr(j, 1) = arr(i, 1)
- arr(i, 1) = temp
- End If
- Next
- Next
- Sheet1.Range("c2:c26") = arr
- End Sub
复制代码 |
|