Find and Replace within Formulas

Hi Adam,

You should be able to select the cells, open the Find/Replace dialog and then click on the Options button to expand the dialog window. Make sure the 'LookIn' drop-down box is set to formulas.

You can then replace something like $F$7 with another cell reference, e.g. C5, G$8, etc.