View Single Post
 
Old 11-18-2018, 01:15 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

a possible option
Code:
Sub Delete_Blank_C_Rows_From_Selection()
    Dim rng As Range
Set rng = Intersect(Columns(3), Selection)
If Not rng Is Nothing Then
    On Error Resume Next    'in case nothing to delete
    rng.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    On Error GoTo 0     're-enable error notification
End If
End Sub
Reply With Quote