VBA Wildcard character help

[tawoodwa]

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?

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

 

[tawoodwa]

Using the Like operator...

"FFM*" should have worked

"[FFM]*" matches any text starting with an F or M

Hey rick I actually retried "FFM*" and its working now, must of had another problem in the code that I didnt notice, thanks everyone for the help