|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub Tag()
- Dim Oj As Object, Str$, Tag%
- Dim Arr, Ary, k%, i%, m%
- [G3:G65536].ClearContents
- Arr = Range("F3", [F65536].End(3)(1, 2))
- Str = Join(Application.Transpose(Application.Index(Arr, , 1)))
- Set Oj = CreateObject("ScriptControl"): Oj.Language = "JScript"
- Oj.eval "function getstr(str){return str.replace(/(的|地)/g,'').match(/[一-龥]+/g,'')}"
- For k = 1 To UBound(Arr)
- If Len(Arr(k, 2)) Then GoTo 1
- Ary = Split(Oj.codeobject.getstr(Arr(k, 1)), ",")
- For i = 0 To UBound(Ary)
- If InStr(Replace(Str, Arr(k, 1), ""), Ary(i)) Then Tag = Tag + 1
- For m = 1 To UBound(Arr)
- If InStr(Arr(m, 1), Ary(i)) And m <> k And Len(Ary(i)) > 1 And Len(Arr(m, 2)) = 0 Then Arr(m, 2) = Tag: Arr(k, 2) = Tag
- Next
- Next
- 1
- Next
- [g3].Resize(k - 1) = Application.Index(Arr, , 2)
- End Sub
复制代码
[ 本帖最后由 alzeng 于 2010-6-30 14:12 编辑 ] |
|