title: Find and replace part of string in one cell with value of cell below it with VBA Macro
body: <p>I have multiple cells on one row in excel that all contain HTML. Each cell is in a different lang but has the same URLs throughout eg: (...loc=en-uk) I need to find and replace this in each cell but with a different value for each cell eg: find "en-uk" in cell A, Replace with "it-it", mover to next cell, find "en-uk", replace with "es-es" and so on till empty cell is reached.</p>
  
  <p>Had tried the following but it only takes find and replace values from the same 2 cells: </p>
  
  <pre><code>Dim Findtext As String 
  Dim Replacetext As String 
  
  Findtext = Range("B2").Value 
  Replacetext = Range("C2").Value 
  Cells.Replace What:=Findtext, Replacement:=Replacetext, LookAt:=xlPart, _
  SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False 
  </code></pre>