using asterisks in a string

Hi,

I have this code:

Please Login or Register  to view this content.

and I need to find all cells in a column which containt the text beginning with "Ras".
But the code above doesn't work because it works with the asterix as if it were a part of the text in the cell.

Can you help please?

If it's string commencement

Please Login or Register  to view this content.

(pending other requirements you may also want to check out the Like Operator in VBA Help)

Note also VBA by default is case sensitive so ras <> Ras / rAs etc...

You could use InStr or you can investigate use of Like as previously mentioned.

InStr
works e.g

Please Login or Register  to view this content.