Hi Dave,

(just in case.)

Yes, the final wildcard should have been included.

Thank you!

---
Regards,
Norman



"Dave Peterson" wrote in message
...
or

What:="*Employment*Government*"

(just in case.)

But to the original poster, if your cell has Government first, then you
may not
want this approach.



Norman Jones wrote:

Hi GreenInIowa,

Try:

What:="*Employment*Government"

---
Regards,
Norman

"GreenInIowa" wrote in message
...
I am trying to find out if a given cell contains the word "Employment"
uising
following code:

Set rngia = Cells(i, 1).Find(What:="Employment", LookIn:=xlValues,
Lookat:=xlPart)

I would like to add another word, "Government" in the same search in
addition to "Employment". I was wondering how can I add multiple words
if
they are not next to each other.

Thanks.

--

Dave Peterson