title: Remove bottom borders from cell range in Excel 2016 VBA - not working?
body: <p>I have a range <code>sh.Range(&quot;F46:I46&quot;)</code> that currently has a thin bottom border that I want to get rid of using VBA, yet the solutions I've tried have failed to work. Right now all I have is:</p>
  <pre><code>sh.Range(&quot;F46:I46&quot;).Borders(xlEdgeBottom).LineStyle = xlNone
  </code></pre>
  <p>I've also tried:</p>
  <pre><code>For Each r In sh.Range(&quot;F46:I46&quot;)
      r.Borders(xlEdgeBottom).LineStyle = xlNone
  Next r
  </code></pre>
  <p>...which is effectively the same thing, <a href="https://stackoverflow.com/questions/24803676/removing-bottom-borders-for-a-range-of-cells">found here</a>, and I've also tried:</p>
  <pre><code>sh.Range(&quot;F46:I46&quot;).Borders.LineStyle = Excel.XlLineStyle.xlLineStyleNone
  </code></pre>
  <p>...which I think is a VB.net code <a href="https://stackoverflow.com/questions/6974965/how-to-remove-borders-from-cells-in-a-range-in-excel-using-vb-net">found here</a>.</p>
  <p>Where am I going wrong????? Thanks!</p>