Macro for Contains

Does anyone know how to program a basic VBA IF statement using Contains.

Something like this:

Please Login or Register  to view this content.

I tried using this:

Please Login or Register  to view this content.

It ran the code without error but didn't seem to actually do what I wanted.

Take a look at the InStr function.

Hope this helps.

Pete

Awesome. I'm off to lunch, but I'll have to try that when I get back.

Doesn't seem to work. I'm not sure how this function is working in order to fix what's wrong. I tried a very simplified version and nothing.

Please Login or Register  to view this content.

There isn't a more straightforward "Contains" command?

I had "Hello" in A1 and "Hello 1" in B1, just for a test. I realize now I had it referencing backwards. A1 did not contain B1 in this case. Reversed the two and all is good. Thanks.