Thread: "FIND" function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GreenInIowa GreenInIowa is offline
external usenet poster
 
Posts: 38
Default "FIND" function

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.