Hi all,
can some one please help me with minute changes to the below code . code should not work if the filter criteria is not available currently it is giving me error if no blanks in the range .
![]()
Sub blamkssss() ActiveSheet.AutoFilterMode = False lr = Range("a" & Rows.Count).End(xlUp).Row Range("AC1:AC" & lr).AutoFilter Field:=1, Criteria1:="=" Range("AC2:AC" & lr).SpecialCells(12).EntireRow.Delete ActiveSheet.AutoFilterMode = False End Sub
Bookmarks