title: vb excel replace part of a word in a cell loop
body: <p>been working with Visual Basic for Excel and have been trying to loop through a huge column of cells and replace part of the cells with an input that i saved to a variable in the code.</p>
  
  <p>For example:</p>
  
  <pre><code>123 
  ip address [ip_address]  255.255.255.255
  345
  678
  </code></pre>
  
  <p>I need to replace the [ip_address] in every cell that it repeats in with the ip address that I input through a userform. The way ive done it so far is I do it manually for each cell and inputting the rest of the constants as strings but I know it can probably be done easier with a sort of loop. Ive tried recording macros and etc Idk if theres another way to do it that might be better than inputing a value into a cell and then copying that value into a variable but thats what I know how to do! Any help would be awesome </p>