It would most likely be due to that. The sample you provided only had short URLs so we didn't anticipate much longer strings.

I assume the text file isn't changed often so it would be easier to edit that to split any of overly long lines by adding a paragraph mark in a logical location than it would be to add complexity to the vba code.

I would expect the maximum string length to be something around a power of 2 eg 64, 128 or 256 characters. You can hover your mouse over the Len(sFind) to see how big the unacceptable number is.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi Guessed,

Thanks for this, I just changed the script (That generates the .txt document) to cull links over 256
I've got one more question, it seems that the VBA macro will highlight any words separated by spaces. Is there a way to instead find and replace by the whole word?
For example if I had the word "Google Account Services" in the .txt document instead of Google, Account and Services being highlighted I only wanted occurrences of the entire word.