Find and replace url in middle of code

[colleenharr]

I'm slightly preplexed on the best way to move forward, so I thought I'd post and ask.

I've got a few lines of code in a cell that contain a http:// address in the middle. I've then got a series of url's in a column - the dream is to be able to do some sort of find and replace or a macro so at the end, each url is plopped into the code line (rest of the code remains the same.)

Does that make sense? Any ideas? My macro writing skills are limited so if there are ideas on where to start for that I would be SO grateful.

 

[poolhall]

when you do the regular Find and Replace procedure, expand the Options dialog and make sure the option 'Match entire cell contents' unchecked, also set 'Look in:' option to 'Formulas'.

 

[colleenharr]

Thanks, that worked on my test case.

Would anyone be able to guide me in a macro for a mass find and replace - the dream output is that for the 100 some URLs I have, each of them is plopped into its own line of code (so i've got 100 lines of code with different URL)