Replace Part of formula Not Work, Why?

[exceere]

Hi everyone,

I have a cell in Sheet3 contains the following formula

Please Login or Register  to view this content.

after i selected the cell, I used the following macro to replace part of the formula:

Please Login or Register  to view this content.

The expected result after replacement occurs it should be like following:

Please Login or Register  to view this content.

But the replacement not occurs. WHY?

[Keebellah]

I don't know why you're doing it but there is a mixi of separators in your code

Please Login or Register  to view this content.

You're using ; and , , something's surely wrong there and probably that's what avoids the modifications.
You MUST get an error

[Rick Rothstein]

Please Login or Register  to view this content.

Your main problem is that all quote marks inside of the quote marks that delineate a text constant must be doubled up. So each "" that I highlighted in red needs to be """" instead. In addition, I notice you switched the comma delineators for your formulas to semi-colons in the Replace function call... if your delineators are commas, then you need to use commas there to.

[exceere]

Thank you Keebellah,
Thank you Rick Rothstein,

Your are correct. I edit the post. (The separators in the functions is ";").

Rick Rothstein, i made a modification on the line as following:

Please Login or Register  to view this content.

And it solves the problem.

Thank you very much.

[Keebellah]

Why do you replace the contents, if you are using macros anyway then I suggest you just rebuild the formula with a macro
Simplest way. start the macro recorder and select the formula, make the change from row 30 to 32 and sop the recorder, then look at the vba code, maybe it'll inspire you.

[exceere]

Keebellah,

Thank you for your suggestion.

[Keebellah]

You're welcome, but did it solve your problem?