Replace function missing strings in a merged range?

[Glitches]

Sup,
I've recently been making a macro in visual basic that loops through all my excel files and replaces an old company name to a new company name and It's working great, well except for one thing... It always misses one string in the file and it leaves me with 90% of the file corrected. I think that the string might be a part of a merged range so Range.Find is not able to find it.
I was suggested to use this code:

Please Login or Register  to view this content.

Because that's the code that is generated when using the replace function in MS Excel 2010, but I keep getting syntax errors?

Any help is extremely appreciated.
Thanks!
Sincerely, Glitches.

[Richard Buttrey]

Without seeing the file in question we can only make informed guesses. However in the code you show you have two full stops .. before the Replace instruction. Try removing one of them.

[Glitches]

Never mind, I figured it out...
I was trying to use "Address.value = replace...." but I was suppose to use "Address.replace..."
Thanks anyways!