|
gdgmwhs 发表于 2013-3-27 15:18
1~7位由0123456789组成的数字 - Sub TONGJI()
- Dim Arr_Source
- Dim Arr_Target(1 To 10)
- Dim i%, j%, k%, Trg$
- Dim D As Object
- Set D = CreateObject("Scripting.Dictionary")
- Arr_Source = Sheets(1).Range("a1").CurrentRegion
- For i = 1 To UBound(Arr_Source)
- For j = 1 To UBound(Arr_Source, 2)
- For k = 1 To Len(Arr_Source(i, j))
- D(Mid(Arr_Source(i, j), k, 1)) = D(Mid(Arr_Source(i, j), k, 1)) + 1
- Next
- Next
- Next
- For i = 0 To 9
- D(i & "") = D(i & "") * 10 + i
- Next
- For i = 1 To 10
- Arr_Target(i) = VBA.Right(WorksheetFunction.Small(D.items, i), 1)
- Next
- Trg = Join(Arr_Target, "")
- Sheets(1).Range("F11") = Trg
- End Sub
复制代码 |
|