Find cells which contain a certain text

[rpinxt]

Hi Guys,
Thought this would not be so hard but I could not get it to work.
The code should find in column B all cells which contain the partial text "Total".

I tried this:

Please Login or Register  to view this content.

But this was probably to simple thought.

Then I tried this also without luck:

Please Login or Register  to view this content.

I would expect several msg boxes but I get none....
Anybody the simple solution?

[djdjdj]

Please Login or Register  to view this content.

should do it

[rpinxt]

arghh...see I knew it could not be that hard
Thanks djdjdj! Worked like a charm.

[Olly]

You could also use:

Please Login or Register  to view this content.

[rpinxt]

Thanks also!