Sub 删除选定列有空格的行()
Dim x As Range
On Error Resume Next
Set x = Application.InputBox(prompt:="请选择要操作的列或者列区域", Title:="提示", Default:="请选择", Type:=8)
If x Is Nothing Then Exit Sub
Range("x").SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
End Sub