Im using this simple code as a part to clean a software export.
The additional criteria i dont know how to implement would be:
delete row if cell in column A is the only cell in said row that holds any value
The additional criteria i dont know how to implement would be:
delete row if cell in column A is the only cell in said row that holds any value
VBA Code:
Sub DelEmptyRows()
lRow = Range("A" & Rows.Count).End(xlUp).Row
Set rngA = Range("A10:A" & lRow)
With ActiveSheet
rngA.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With
End Sub