|
楼主 |
发表于 2019-4-21 20:02
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 jokerone 于 2019-4-21 22:10 编辑
Sub test()
Dim Arr, j&, i&, rng As Range, brandname
Application.ScreenUpdating = False
brandname = Array("asics", "adidas") '这里可以加上你要删除的品牌名
Arr = [a1].CurrentRegion
For i = 1 To UBound(Arr)
For j = 0 To UBound(tj)
If InStr(Arr(i, 1), brandname(j)) Then
If rng Is Nothing Then Set rng = Rows(i): Exit For Else Set rng = Union(rng, Rows(i)): Exit For
End If
Next
Next
If Not rng Is Nothing Then rng.Delete Shift:=xlUp
MsgBox "删除操作完成!"
Application.ScreenUpdating = True
End Sub |
|