I have this code, and it works perfect when the value is exactly when its "FFM-BLS15.01.00", but i need to adapt the code so that it catches all cells with "FFM" at the beginning, I tried using "FFM*" but apparently you cant use that wildcard character with an = operator. Can anyone please help me rewrite this so that it works that way?
Code:
With worksheet_to_process
Dim LR As Long, i As Long
LR = worksheet_to_process.Range("A" & Rows.Count).End(xlUp).Row
For i = 1 To LR
With worksheet_to_process.Range("B" & i)
If .Value = "FFM-BLS15.01.00" Then
worksheet_to_process.Rows(i).Select
Selection.Delete Shift:=xlUp
i = i - 1
End If
End With
Next i
End With