title: How to replace a part of formula and modify it using excel VBA?
body: <p>Let's say I have a column in excel where many cells are populated with values from sheets and a formula. For example, a cell has '82'!G7*2*F3^2*$F$6. (where 82 is the name of the sheet values are coming from. I want to write a for or loop that goes through all the cells and change all the 82s to something else, 85 for example. and also the $F$s to $H$. </p>
  
  <p>What's the code to find these certain parts to then be able to replace them within the formula or whatever it is that is in a cell?</p>