title: Looping through all the string values of cell by vba
body: <p>So this is what I want to do:</p>
  <p>For example, in the sheet named &quot;Outputs&quot;, the A1 cell input is
  = &quot;abcd&quot; &amp; Input!A5 &amp; &quot;efgh&quot;,
  where Input!A5 is the cell value of the different sheet in the excel file.</p>
  <p>I want to make it change so that after executing all the methods after selecting the A1 cell as
  = &quot;abcd&quot; &amp; Input!A5 &amp; &quot;efgh&quot;, I want to change the A1 cell as, = &quot;abcd&quot; &amp; Input!A6 &amp; &quot;efgh&quot;, and then = &quot;abcd&quot; &amp; Input!A7 &amp; &quot;efgh&quot; and so on. (So it's basically replacing the values as A1 to Ai)</p>
  <p>I thought of using Replace function, by writing the replacing string as Ai, and replacing i with i +1 by starting with for loop.</p>
  <p>But I don't think this is a right method.
  Could anyone shed light on how to address this?</p>
  <p>Thanks in advance.</p>