Vba delete entire row if contains certain text in ExcelVBA Delete Entire Row if Contains Certain Text
I've searched on here, but every code I put in gives me an error back. Data in column D, If any of the cells contains "Record Only" I need it to delete the entire row.
lastRow = Cells(Rows.Count, "D").End(xlUp).Row
For i = lastRow To 1 Step -1
If (Cells(i, "D").Value) = "Record Only" Then
(for formulas, depending on your country, you might have to change ; with , or the opposite