Thread: "FIND" function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default "FIND" function

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.