|
- Sub 删除整行空白行()
- Dim arr, rng As Range, c As Range, i&, x%
- Set c = ActiveSheet.UsedRange
- If IsEmpty(ActiveSheet.UsedRange) Then MsgBox "当前工作表中没有数据!", vbInformation + vbOKOnly, "提示": Exit Sub
- arr = Cells(1, c(1).Column).Resize(c(1).Row + c.Rows.Count - 1, c.Columns.Count)
- x = UBound(arr, 2)
- Application.ScreenUpdating = False
- For i = 1 To UBound(arr)
- If Application.CountA(Cells(i, 1).Resize(1, x)) = 0 Then
- If rng Is Nothing Then Set rng = Cells(i, 1) Else Set rng = Union(rng, Cells(i, 1))
- End If
- Next
- If Not rng Is Nothing Then rng.EntireRow.Delete
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|