I'd like to find and replace parts of each formula on a spreadsheet.

"Range.Find ... LookIn:=xlFormulas" does the job of Find, but not the job of Replace. However, "Range.Replace" does not look in a formula, just cell values.

Is there any fixed function doing the job? Any help is appreciated.