且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

自动过滤后删除空白行

更新时间:2023-12-03 20:00:10

如果你需要做的就是在列 A ,您不需要过滤,只需:

If all you need to do is to delete rows with blanks in column A , you don't need to filter, just:

Sub DeleteRows()
    Range("A:A").Cells.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub