title: How do I take text from cell A1 and put it in the middle of a sentence in another cell?
body: <p>I am trying to take text from cell A1 and use it within the text of another cell on the same sheet, let's call it cell A20, by using VBA. If cell A1 said "dog", I want the code to insert that word in the middle of the pre-existing text in cell A20, "My favorite thing about my <strong>__</strong> is its color." </p>
  
  <p>For clarity, I'll say that the rest of the text in cell A20 will never change, so it can be typed into the code itself if that's easiest (I'd probably prefer that anyway). Hopefully this makes some sense, but please comment and let me know if it doesn't. Thanks in advance to whoever helps me out!</p>