|
发表于 2016-6-21 16:26
|
显示全部楼层
本楼为最佳答案
代码如下:- Sub xx()
- Dim arr, n&, i&, x&, y&
- With Sheet1
- n = .Cells(.Rows.Count, 2).End(xlUp).Row
- arr = .Range("B1:B" & n)
- For i = 1 To n
- If arr(i, 1) = "序号" Then x = i
- If arr(i, 1) = "合计" Then
- y = i
- Exit For
- End If
- Next
- .Rows(x + 1 & ":" & y - 1).Delete
- End With
- End Sub
复制代码 |
|