replacing text in a cell without deleting formula

[keymaster]

I have read some of the help and i copied and pasted some VBA that applies to my issue, but it does not work.

Please Login or Register  to view this content.

is what i am tryin to use but the formula has quotes in it. I have tried to use the &chr(23) but still not working.

I have a sheet data is pulled from to fill out cells on another. I have another tab for substitutions for names on the end result tab that references the data tabs, but the VBA does not work so when I type something in the cell it just deletes the formula that is needed if there is no change.

[Logit]

.
When using formulas in a macro ... anything that would normally be in quotes if it were written directly into a cell, must be enclosed in double quotes
in the macro.

Ex: If you were to enter .... ="22" .... in cell A1

Then you were to write a macro that included the same formula ... it would need to be written ... =""22""

[Rick Rothstein]

Quote marks inside of a quoted string should be doubled up (otherwise VB cannot tell if the single quote is the end of a quoted text string or an internal quote mark). So, if your text is this...

I am a "quoted" text string

you would assign it to a variable like this...

Variable = "I am a ""quoted"" text string"

[keymaster]

Still just deletes it