Find.range to return True if match occurs

Hey

I need to get a value from a cell and check wheter it exists in a range.

Right now I have:

Please Login or Register  to view this content.

This doesn't work as I wanted. Also, I think it is very slow.

I'd like to achieve something in the way:

Please Login or Register  to view this content.

Where the function would be something like:

Please Login or Register  to view this content.

Now, I am very new to VBA, so my questions are:

- Can I have a Range.find function which returns True if a match occurs?

Why do I want that? Well, looping through the cells is very slow (I'd like the code to be as fast as possible) and using Application.Functions doesn't seem right to me, especially because I read that they aren't fast either.

Thx

I recommend using the excel formula Countif
If you need it in VBA, use Worksheetfunction.Countif