title: Setting cell that contains specific text as the first cell, or "x"
body: <p>Have the below scenario;</p>
  <ul>
  <li>Worksheet with a cell (A30) that contains text &quot;Important Notes/Terms&quot;.</li>
  <li>Macro that adds text to the row A31 (i.e. after &quot;Important Notes/Terms&quot;) depending on a product code (with it's own notes/terms).</li>
  <li>When I add a product as a new row, the cells shifts downwards which means &quot;Important Notes/Terms&quot; is no longer A30.</li>
  </ul>
  <p>How do I set &quot;Important Notes/Terms&quot; as the first cell? E.g. if I set this first cell as &quot;x&quot;, I want to be able to have on the macro something along the lines of</p>
  <p><code>Cells(x + 1, 1).Value = &quot;Notes/disclaimer for Product 2&quot;</code></p>
  <p>Where x is the cell that contains &quot;Important Notes/Terms&quot;. There will only ever be one x on the sheet.</p>
  <p>Thank you.</p>