|
请参考
Private Sub CommandButton1_Click()
Dim arr, d, i&, j%, k%
Dim brr(), crr
Dim k1%, k2%
Sheet2.Activate
Sheet1.[b3:J26] = ""
arr = Range("a1").CurrentRegion
For j = 2 To 10
ReDim brr(1 To UBound(arr), 1 To 2)
For i = 3 To UBound(arr)
brr(i, 1) = i 'Record Rows
brr(i, 2) = arr(i, j) 'Record Number
Next
crr = Bubble_sort(brr)
For k = 3 To 7
k1 = crr(k, 1)
If Not crr(k1, 2) = "" Then
With Sheet1.Cells(k1, j)
.Value = Chr(-24079)
.Font.Color = -11489280
End With
End If
Next
For k = 3 To 10
k2 = crr(UBound(brr) + 3 - k, 1)
If Not crr(k2, 2) = "" Then
With Sheet1.Cells(k2, j)
.Value = Chr(-24079)
.Font.Color = -16776961
End With
End If
Next
Next
Sheet1.Activate
Call Sheet1.sumcolor1
Call Sheet1.sumcolor2
End Sub
Function Bubble_sort(brr)
Dim i, j
Dim vSwap(1 To 2)
For i = 3 To UBound(brr)
For j = i + 1 To UBound(brr)
If brr(i, 2) < brr(j, 2) Then
vSwap(1) = brr(j, 1): vSwap(2) = brr(j, 2)
brr(j, 1) = brr(i, 1): brr(j, 2) = brr(i, 2)
brr(i, 1) = vSwap(1): brr(i, 2) = vSwap(2)
End If
Next j
Next i
Bubble_sort = brr
End Function
|
评分
-
1
查看全部评分
-
|