|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 shenjianrong163 于 2020-2-21 13:31 编辑
正则替换:- Sub test()
- Dim i, r, arr
- Application.ScreenUpdating = False
- Set oRegExp = CreateObject("vbscript.regexp")
- With oRegExp
- .Global = True
- .IgnoreCase = True
- .Pattern = "^[\.\w+$]"
- End With
- With Sheets("sheet1")
- r = .Cells(.Rows.Count, 2).End(xlUp).Row
- arr = .Range("B3:D" & r)
- For i = 1 To UBound(arr)
- arr(i, 3) = oRegExp.Replace(arr(i, 1), arr(i, 2))
- Next
- .[B3].Resize(UBound(arr), 3) = arr
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|