Delete row if cell in specific column contains a certain word

[tipd]

I have a Sub created and need to add into that Sub at the end of it to go search column C for the word Prestige and if column C says Prestige, it will delete that whole row and move the next line up. I need it to search the whole column C which will have more or less rows each time.

When I search for this, I find a lot of Dim starting codes but will those work within a already created Sub?

 

[rpaulson]

...

 Application.ScreenUpdating = False
On Error Resume Next
    With Range("C:C")
        .Replace "Prestige", False, xlWhole
        .SpecialCells(xlCellTypeConstants, 4).EntireRow.Delete
    End With
On Error GoTo 0
 Application.ScreenUpdating = True
End Sub

 

[tipd]

...

 Application.ScreenUpdating = False
On Error Resume Next
    With Range("C:C")
        .Replace "Prestige", False, xlWhole
        .SpecialCells(xlCellTypeConstants, 4).EntireRow.Delete
    End With
On Error GoTo 0
 Application.ScreenUpdating = True
End Sub

Thank you so much!