Automating Find & Replace

Originally Posted by PCI

PharmerGuy,
Why you don't use names!
For example in sheet "Code Sheet" cell D2 is named "Company_address" then in sheet "Scope" in cell C8 put = Company_address
PCI

That would be simplest but there is multiple text in one cell. The replacement function is usually a set of words within a larger paragraph.