Found this by Rick Rothstein from January 25, 2012. (Yes I have seen the date)
If your entries in Column 2 are text constants (that is, there are no formulas in the column), then this non-looping macro should do what you want quite quickly...
I need to alter it so it deletes the row below too. Anyone know how?
If your entries in Column 2 are text constants (that is, there are no formulas in the column), then this non-looping macro should do what you want quite quickly...
I need to alter it so it deletes the row below too. Anyone know how?
Code:
Sub DeleteRowsInColumn2WithTempInThem()
On Error Resume Next
With Columns("B")
.Replace "*temp*", "=1", xlWhole
.SpecialCells(xlFormulas).EntireRow.Delete
End With
End Sub