|
- Sub test()
- arr = Range("aa12").CurrentRegion
- Dim s(1 To 3, 1 To 1), w(9)
- For Each x In arr
- If Len(x) = 3 Then
- For j = 1 To 3
- w(Val(Mid(x, j, 1))) = 1
- Next
- k = Len(Join(w, ""))
- s(k, 1) = s(k, 1) + 1
- Erase w
- End If
- Next
- [b7].Resize(3, 1) = s
- End Sub
复制代码 |
|