jeudi 24 novembre 2016

excel vba i have to find a specific set of letters amongst many in one cell

I want to do.

    If Cells(1,1).Value = "XYZ" then 
    'something' 

But there can be other letters in the cell. like a cell [ZZZ XYZ YYY WWW]. How do i get around that XYZ can be anywhere in that cell. only find that specific order of the letters. And if its not in that specific cell the if command should not trigger.

hope someone can help.

Aucun commentaire:

Enregistrer un commentaire