#1
|
|||
|
|||
Find and Replace - Variable change
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? |
#2
|
||||
|
||||
You could make a macro!
Steps:
If you create the macro and paste the working code here, I'll help with the loop if you want. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and Replace is not working | Brigitte | Word | 7 | 06-15-2021 05:10 PM |
help with find and replace | sjkiss | Word | 1 | 04-12-2010 08:08 AM |
Find & Replace Insert Issue | mipacker | Word | 0 | 02-18-2009 08:59 AM |
Find and Replace Macro - A Better Way | Tribos | Word VBA | 0 | 10-08-2008 03:22 AM |
Find and Replace box flies off screen! | M Skabialka | Word | 2 | 06-06-2006 10:05 AM |