|
用8楼修改一下
Sub 品牌特性()
Dim ar, re
Dim Rnum As Integer, i As Integer
Dim str As String, mats As Object, mat As Object
Dim objregexp As Object
Set objregexp = CreateObject("VBScript.regExp")
Rnum = Sheets(1).[b65536].End(3).Row
ar = Sheets(1).Range("B2:B" & Rnum)
ReDim re(1 To UBound(ar), 1 To 1)
For i = 1 To UBound(ar)
If InStr(ar(i, 1), "(") > 0 Then
str = "\(\w+\d+\)"
Else
str = "[A-Z]{2,}"
End If
temp = ""
With objregexp
.Global = True
.Pattern = str
Set mats = .Execute(ar(i, 1))
For Each mat In mats
temp = temp & mat
Next
End With
If InStr(temp, "(") > 0 Then
re(i, 1) = Replace(Replace(temp, "(", ""), ")", "")
Else
re(i, 1) = temp
End If
Next i
Sheets(1).[a2].Resize(UBound(re)) = re
End Sub |
|