Sub Click()
Dim A, B, d, i, j
A = Range("c2:d" & Range("c65536").End(xlUp).Row)
Set d = CreateObject("scripting.dictionary")
For i = 1 To UBound(A)
d(CStr(A(i, 1))) = A(i, 2)
Next i
A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
B = VBA.Split(A(i, 1), Chr(41900))
For j = 0 To UBound(B)
B(j) = d(CStr(B(j)))
Next j
A(i, 1) = VBA.Join(B, Chr(41900))
Next i
[f1].Resize(UBound(A)) = A
End Sub
替换案例2.rar
(20.08 KB, 下载次数: 14)