title: VBA Code to enter the same value in a range of cells in the next available row
body: <p>Hope someone can help.</p>
  <p>I have an inventory tab and the inventory of several parts in a table on the worksheet.</p>
  <p>When a new part is added to inventory it gets placed at the bottom of the table.</p>
  <p>Before any inventory transactions are made the inventory is set to 0 for multiple locations.</p>
  <p>For the purpose of this question, the new part I am adding is &quot;Example P/N 14&quot; with the description &quot;Example Description 14&quot;. And these have been added to cells &quot;A15:B15&quot;</p>
  <p>I would now like to add the value &quot;0&quot; for the next available row for the range of &quot;C:S&quot;</p>
  <p>So for this part, I would need &quot;0&quot; adding to the Range &quot;C15:S15&quot;</p>
  <p>This will change each time though.</p>
  <p>For example, the next new part that is added will be in row 16, so I will need my code to find the next available row (Being Row 16) and so on and so forth each time a new part is added.</p>
  <p>Please see the link for the example table below:</p>
  <p>Table Example:</p>
  <p><a href="https://i.stack.imgur.com/V32TF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V32TF.png" alt="enter image description here" /></a></p>
  <p>Thank you in advance for your help.</p>