|
楼主 |
发表于 2016-11-1 11:34
|
显示全部楼层
Sub test()
Dim str, reg, match, matchs, x
Set reg = CreateObject("VBScript.RegExp")
reg.Global = True
紫色关键词 = Array("/", "主梁", "次梁", "网架", "悬索", "筒壳", "框架", "剪力", "装配整体式", "连梁", "钢筋混凝土梁", "全熔透焊缝连接", "摩擦型高强螺栓连接", "全焊接连接")
For i = 0 To UBound(紫色关键词)
str = 紫色关键词(i)
For Each x In ActiveSheet.UsedRange
If InStr(x, str) Then '''''''''''''''''''''''''''''''''''''''''''''''''错误13类型不匹配??????
On Error Resume Next
x.Font.ColorIndex = xlAutomatic
reg.Pattern = str
Set matchs = reg.Execute(x)
For Each match In matchs
x.Characters(Start:=match.firstindex + 1, Length:=match.Length).Font.ColorIndex = 3
Next
End If
Next
Next
End Sub
|
|