|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub 批量删除()
- Dim MaxRw As Long, Rw As Long, Rng As Range, Rg As Range
- MaxRw = Cells(Rows.Count, 1).End(xlUp).Row
- For Each Rng In Range("A1:A" & MaxRw)
- If Rng.Value = "序号" Then
- For Rw = Rng.Row + 1 To MaxRw
- If Rng.Offset(Rw, 0) = "删除" Then
- If Rg Is Nothing Then
- Set Rg = Range(Cells(Rng.Row + 1, 1), Cells(Rng.Offset(Rw - 1, 0).Row, 1))
- Else
- Set Rg = Union(Rg, Range(Cells(Rng.Row + 1, 1), Cells(Rng.Offset(Rw - 1, 0).Row, 1)))
- End If
- End If
- Next Rw
- End If
- Next Rng
- Rg.EntireRow.Delete
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|