If I set up a spreadsheet that includes references of the form =C3 etc, if I
then define a name for cell C3 (eg "cost"), then I have to manually go back
through the spreadsheet to find references to C3 and change them to the name.

Is there a clever way (other than find and replace) to automatically or via
macro etc to go through a spreadsheet at replace all relative references with
the name reference?

Any ideas?