|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
改了下你可以用
Sub test()
Dim r%, i%
Dim arr, brr
Dim rng As Range
Dim reg As Object
Set reg = CreateObject("vbscript.regexp")
With reg
.Global = True
.Pattern = "中(号|式)"
End With
With Worksheets("sheet1")
AutoFilterMode = False
.Rows.Hidden = False
r = .Cells(.Rows.Count, 1).End(xlUp).Row
For i = 2 To r
If Not reg.test(.Cells(i, 5)) Then
If rng Is Nothing Then
Set rng = .Rows(i)
Else
Set rng = Union(rng, .Rows(i))
End If
End If
Next
If Not rng Is Nothing Then
rng.Rows.Hidden = True
End If
End With
End Sub |
评分
-
1
查看全部评分
-
|