Hi Dudes, I wonder if you can help ...

I want to do something involving find and replace and I'm not sure if it is possible, i.e.

I have a worksheet with a a number of links to other worksheets so, in cell H157 will me an addition link saying:

=+'\\Path\path\folder\[file A.xls]sheet name'!H157+'\\Path\path\folder\[file B.xls]sheet name'!H157

I want to add 'file C.xls' to the formulae and end up with:

=+'\\Path\path\folder\[file A.xls]sheet name'!H157+'\\Path\path\folder\[file B.xls]sheet name'!H157+'\\Path\path\folder\[file C.xls]sheet name'!H157

HOWEVER this formulae is repeated throughout the worksheet with only the cell reference changing. Thus I am looking to add the extra file addition on via a Find and Replace. I don't think I can do it because the cell reference will change in every case.

Is this possible to automate?