I have code to delete all rows in Col C from row 4 onwards except whre the text contains BRFM for eg BRFM REDIT
I am struggling with this part below
If Cells(LR, 3) <> Like "BRFM*" Then
Sub Delete_Unwanted()
Sheets(2).Select
Dim LastRow As Long
Dim LR As Long
'fetch the count of...