title: Excel Macro: Between Named Rows, Cell to Equal Zero if Another Cell = "c"
body: <p>I have data in Columns H, I and J between two named rows, &quot;BorderFirstRow&quot; at the top and &quot;BorderLastRow&quot; at the bottom.  I'm using the named rows because the number of rows in between is always changing as information is added or deleted.</p>
  <p>I'm trying to create a macro with a section that sets a value of zero in the H, I and J cells if the correlating cell of the same row in Column AA = &quot;c&quot;</p>
  <p>I haven't tried anything because I'm really at a loss as to where to start since I'm not good with fluctuating data ranges.  I've used the following to set the range in the past when I was looking to sort the data but not sure if it is applicable as a solution?</p>
  <pre><code>With .Range(.Cells(.Range(&quot;BorderFirstRow&quot;).Row + 1, &quot;H&quot;), _
           .Cells(.Range(&quot;BorderLastRow&quot;).Row - 1, &quot;J&quot;))
  </code></pre>