Hi all -
I've found plenty of examples on how to search for text in a column and delete said column if text is found. My case is slightly different, I need the starting position of the search to begin starting at C3, and searching for two words.
I found this example, of how to search the entire column for one word.
I've found plenty of examples on how to search for text in a column and delete said column if text is found. My case is slightly different, I need the starting position of the search to begin starting at C3, and searching for two words.
I found this example, of how to search the entire column for one word.
VBA Code:
Dim lr As Long
Dim Found As Range
lr = Range("C" & Rows.Count).End(xlUp).Row
Set Found = Columns("C").Find(what:="Parts", LookIn:=xlValues, lookat:=xlWhole) ' also need to search for "Certified"
If Not Found Is Nothing Then Rows(Found.Row & ":" & lr).Delete