macro findwhat muliple values

[rickmeister]

I have the following vba code, however I would like to reinforce the rule by incuding B1 should contain Virtual but also POPU. Any idea how to tackle this?
field B1 is structured as follows: "POPU_Txxx(Virtual Table"


'8A: Find "Column number" on the sheet
Set findRNG = sheetje.Range("B1").Find(What:="Virtual")

Thanks!!!

[ragulduy]

If POPU is always before Virtual in the text string you could probably get away with:

Please Login or Register  to view this content.

[rickmeister]

great !! thanks !!!