title: VBA Delete Border around Range
body: <p>I need to clear the old range border before applying the new one with the change, I've been trying with no success. It should be done before the <code>'Set New Duration</code> in holding cell.</p>
  <p>How can I achieve this?</p>
  <pre><code>If Cells(9, Target.Column).Value = &quot;Dur&quot; Then 'Duration Change and Check for proper database column
                  
                  'Update Colors
                  
                  'Clears Old Color
                  
                  If Range(&quot;A8&quot;).Value &lt;&gt; Empty Then Range(Cells(Target.Row, Target.Column), Cells(Target.Row + Range(&quot;A8&quot;).Value - 1, Target.Column + 3)).Interior.Color = 16777215 'Clear Previous Colors Based on Previous Duration (if any)
                               
                  'Set New Duration in holding cell
                  Range(&quot;A7&quot;).Value = Target.Value
                  
                  'Sets New color
                  If Target.Value &lt;&gt; Empty Then Range(Cells(Target.Row, Target.Column), Cells(Target.Row + Range(&quot;A8&quot;).Value - 1, Target.Column + 3)).Interior.Color = Range(&quot;FillColor&quot;).Interior.Color  'Add New Color
                  
                  'Sets Border around
                  If Target.Value &lt;&gt; Empty Then Range(Cells(Target.Row, Target.Column), Cells(Target.Row + Range(&quot;A8&quot;).Value - 1, Target.Column + 3)).BorderAround , ColorIndex:=xlAutomatic, Weight:=xlThin
  
  End If
  </code></pre>