|
本帖最后由 hoyan 于 2017-5-25 19:29 编辑
大神们好!想请问一下,如图,如何将 表1 中的个形容词所对应的类别匹配替换到 表2 的文本内容中并能够下拉批量替换,非常感谢!
试试,结果生成在J列!{:2012:} - Sub th()
- Dim ar, br
- Dim i As Long
- ar = Range("A2:A" & Cells(Rows.Count, 1).End(3).Row)
- br = Range("E2:F" & Cells(Rows.Count, 5).End(3).Row)
- For i = 1 To UBound(ar)
- For j = 1 To UBound(br)
- If ar(i, 1) Like "*" & br(j, 2) & "*" Then ar(i, 1) = Replace(ar(i, 1), br(j, 2), br(j, 1))
- Next j
- Next i
- With Cells(1, 10)
- .Resize(Rows.Count).ClearContents
- .Resize(i - 1) = ar
- End With
- End Sub
复制代码
|
|