I have the code below and am trying to delete rows where a value of 15W99 shows and rows where teh value 15W99 is showing in column C - I don't understand what I am doing wrong, but does not seem to work.
Dim Lst As Long
Dim n As Long
Lst = .Range("C" & .Rows.Count).End(xlUp).Row
For n = Lst To 2 Step -1
With .Range("C" & n)
If .Value = "15W99" And _
.Value = "9RCP8" Then .EntireRow.Delete