|
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim reg As New RegExp
- With reg
- .Global = True
- .Pattern = "\d楼[A-Z]\d"
- End With
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- .Range("c2:c" & r).ClearContents
- arr = .Range("a2:c" & r)
- For i = 1 To UBound(arr)
- Set mh1 = reg.Execute(arr(i, 1))
- Set mh2 = reg.Execute(arr(i, 2))
- If mh1.Count > 0 And mh2.Count > 0 Then
- If mh1(0) = mh2(0) Then
- arr(i, 3) = True
- Else
- arr(i, 3) = False
- End If
- End If
- Next
- .Range("a2").Resize(UBound(arr), UBound(arr, 2)) = arr
- End With
- End Sub
复制代码 |
|