Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-16-2009, 02:48 AM
Ssendam Ssendam is offline Find and Replace - Variable change Windows XP Find and Replace - Variable change Office 2007
Novice
Find and Replace - Variable change
 
Join Date: Jul 2009
Posts: 1
Ssendam is on a distinguished road
Default 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?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace - Variable change 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 - Variable change Find and Replace box flies off screen! M Skabialka Word 2 06-06-2006 10:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft