Find and Replace for longer strings?

Now and then I run into the problem where the string I am searching for or replacing with is too long and either won't fit in the text field or allow me to replace it. How can I do this? I've read a little about the `replace` function but it doesn't look like it will do what I am after at this moment.

Example of what I am trying to do... I am trying to replace a section of old HTML with a section of new HTML. The HTML below is only part of the text in each cell:

OLD HTML

Please Login or Register  to view this content.

NEW HTML

Please Login or Register  to view this content.

Try putting Option Explicit at the top of the module. What happens?

Good job !