all it was that i wanted to search for a text strings but it could have text before it so i wondered if i can do a multiple search like criteria
if cell.value like "*aa" or "*bb" etc...
Yes, I understood that, and I have answered that as best I can.
However, my answer wouldn't have helped you so I'm trying to get you to be specific
to see if I might be able to help.
For example, does 'etc' mean you have a total of 3 strings to compare or 300?
How long are the actual strings you are looking for?
Are there any patterns in the strings?
Could you give some examples of the actual strings you are searching for? (I'm assuming you are not actually searching for 'aaa', 'bbb', 'ddd' & 'fff')
How many cells are you going to look for these strings in?
I'm just trying to get an understanding of what you actually
have and are actually
trying to achieve.