I'm in the process of learning VBA and am having some troubles writing
an excel macro to find all instances of a word (usually in conjunction
with other words) and delete the row containing it

essentially I'd like row 5 below to do the following:

If Cell contains word *foo* OR *baz* then

such that it would find individual instances of foo and baz but also
foobar

Although overall a rather large macro, the code surrounding


1 Cells.Sort Key1:=Range("C1")
2
3 totalrows = ActiveSheet.UsedRange.Rows.Count
4 For Row = totalrows To 2 Step -1
5 IF CELLS(ROW, 3).VALUE = **FOO** OR CELL(ROW, 3).VALUE=
**BAZ** Then
6 Rows(Row).Delete
7 End If
8 Next Row

Thanks!

--Chris