I have found the following code that does almost what I want. It deletes a row if a certain character is found in the row. What I need is the row to be deleted if specific character appears first in that row. For example if "C" is the first character in row 23 than that row will be deleted, but if "C" is the 10th character in row 24 it will not be delected. Any help is appreciated. Thanks
Code:
Option Compare Text
Sub DeleteRows()
Dim LstRw As Long, Rw As Long
LstRw = Cells(Rows.Count, "A").End(xlUp).Row
Application.ScreenUpdating = False
For Rw = LstRw To 1 Step -1
If InStr(Cells(Rw, "A"), "F") Or InStr(Cells(Rw, "A"), "C") Then _
Rows(Rw).EntireRow.Delete
Next Rw
Application.ScreenUpdating = True
End Sub