|
发表于 2016-6-8 10:44
|
显示全部楼层
本楼为最佳答案
代码如下:- Sub 删行2()
- Dim rng As Range, i&, j&, rng1 As Range, rng2 As Range
- Set rng = Sheet1.Range("F4:F31")
- For i = 27 To 1 Step -2
- If rng(i, 1) = "" Then
- rng(i, 1).Resize(2, 1).EntireRow.Delete
- End If
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|