View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucas Lucas is offline
external usenet poster
 
Posts: 18
Default find multiple or by different words

Hello,

I would like to us the find function on a sheet to search for either of 2
words.
If I want to search for multiple words for example A and B I use:

..Find(what:="A" & "*" & "B",

But what do I use if i want to search for A OR B.
I know I can first search for A and subsequently for B but I would like to
use a single find function.

thanks in advance!
Lucas van Rijsewijk
Deurne, The Netherlands