|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Count <> 1 Then Exit Sub
- If Target.Row <> 31 Then Exit Sub
- If Len(Target) = 0 Then Exit Sub
- c = Target.Column
- Dim arr(), brr()
- ReDim arr(1 To Sheets.Count, 1 To 15)
- For Each sht In Sheets
- crr = sht.Cells(31, c).Resize(1, 15)
- For i = 1 To UBound(crr, 2)
- arr(sht.Index, i) = crr(1, i)
- Next i
- Next sht
- Cells(33, c).Resize(UBound(arr), UBound(arr, 2)) = arr
-
- ReDim brr(1 To UBound(arr) + 1, 1 To 11)
- Set d = CreateObject("scripting.dictionary")
- For i = 0 To 9
- brr(1, 2 + i) = i
- Next i
- brr(1, 1) = ""
- For j = 1 To UBound(arr)
- d.RemoveAll
- For i = 1 To UBound(arr, 2)
- d(arr(j, i)) = d(arr(j, i)) + 1
- Next i
- x = ""
- For i = 9 To 0 Step -1
- brr(j + 1, i + 2) = d(i) + 0
- If d(i) = 0 Then x = x & i
- Next i
- brr(j + 1, 1) = x
- Next j
- Cells(45, c).Resize(UBound(arr), UBound(brr, 2)) = brr
- End Sub
复制代码 |
评分
-
2
查看全部评分
-
|