Microsoft Office Forums - View Single Post - [Solved] Set Range based on selected rows.

Logit · 11-18-2018, 10:32 AM

.
You have indicated you are manually selecting the rows to be deleted. This macro will do that :

Code:

Sub DelRows()
    Selection.EntireRow.Delete
End Sub

If you don't want to manually select the rows, but rather have it done automatically, use this macro :

Code:

Sub DelCRows()
    Columns("C:C").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub