|
忙乎半天 才发现 VBA内这些字符识别不出来
代码是按照一般字符做的,可以参考一下
字根.rar
(124.71 KB, 下载次数: 0)
- Sub OPI()
-
- Set SHX = Worksheets("Sheet2")
- SHX.AutoFilterMode = False '//取消筛选
- MAXROW = SHX.Range("a" & SHX.Rows.Count).End(3).Row
- ARX = SHX.Range("A2:" & SHX.Cells(MAXROW, "A").Address).Value
-
- Set SHD = Worksheets("Sheet1")
- SHD.AutoFilterMode = False '//取消筛选
- MAXROW = SHD.Range("a" & SHD.Rows.Count).End(3).Row
- ' DRX = SHD.Range("A3:" & SHD.Cells(MAXROW, "C").Address).Value
- Set ZDD = CreateObject("Scripting.Dictionary")
- ' For I = 1 To UBound(DRX, 1)
- ' If InStr(DRX(I, 3), SHX.Range("F2").Value) > 0 Then
- ' ZDD(DRX(I, 2)) = DRX(I, 1)
- ' End If
- ' Next
- For I = 3 To MAXROW
- If InStr(SHD.Cells(I, "C").Value, SHX.Range("F2").Value) > 0 Then
- ZDD(SHD.Cells(I, "B").Value) = SHD.Cells(I, "C").Value
- End If
- Next
-
- Set ZAD = CreateObject("Scripting.Dictionary")
- For I = 1 To UBound(ARX, 1)
- For X = 1 To Len(ARX(I, 1))
- StrX = Mid(ARX(I, 1), X, 1)
- If ZDD.exists(StrX) = True Then
- ZAD(ARX(I, 1)) = StrX
- Exit For
- End If
- Next
- Next
-
- ERX = ZAD.KEYS
- SHX.Range("F3:F" & SHX.Rows.Count).ClearContents
- For X = 0 To UBound(ERX)
- SHX.Cells(X + 3, "F").Value = ERX(X)
- Next
-
- End Sub
复制代码 |
|