VBA 'If' statement with wildcard

[Rags]

Hi

How do you put a wildcard in an 'If' statement in VBA? Similar to this:

Meaning If the cell contains 'Capital'

If Cells(C, 3) = "*Capital*" Then.......

Thanks

Rags

 

[Andrew Poulsom]

Try:

If Instr(1, Cells(C, 3).Value, "Capital") Then

You may also want to look at the Like Operator in VBA Help.

 

[Rags]

Thanks very much Andrew. Works perfectly and will be most useful

 

[Davefrisch]

http://mrexcel.com/forum/member.php?u=6222
Andrew Poulsom, thanks for answering this question! I also had the same question and had been searching for over an hour.