|
- Sub 不重复字母()
- Dim arr, d As Object, RAN
- On Error Resume Next
- Set d = CreateObject("scripting.dictionary")
- Sheet1.Range("F:G").Clear
- arr = Sheet1.UsedRange
- d("字符") = "出现次数"
- For Each RAN In arr
- 'If TypeName(RAN) = "String" Then '如果 2011.10.1 不按日期格式处理 用这一句
- If TypeName(RAN) = "String" And Not IsDate(Replace(RAN, ".", "-")) Then
- d(RAN) = d(RAN) + 1
- End If
- Next
- Sheet1.Range("F1").Resize(d.Count) = Application.Transpose(d.Keys)
- Sheet1.Range("G1").Resize(d.Count) = Application.Transpose(d.Items)
- End Sub
复制代码
|
|