I have an IF statement:

If Range("a:a").Find(what:="DEV") Is Nothing Then
Range("a16").EntireRow.Insert shift:=xlDown
End If

Now i found out that I have more words to find in column A.

Here's what I need to look for:
DDC
DDCE
DEV
DTS
EXT
PUP
RIC
RIP
STD

Is there a way I can incoporate all these into 1 IF statement ?
Anyone have a bit of code to help? By the way, the above order is ho
it's generated in the file

--
Message posted from http://www.ExcelForum.com