Hi all,

Goal: if a value is in Column B, have the inside border auto fill down, in Columns D through BE.
From Row 5 down to that row.

This works for the row where i put the value in Column B but if i clear out some of the bottom rows
in Column B the Format stays.

I guess what i am trying to do is clear the format on that row if the value
in Column B is tken out. Been trying some IF / ELSE stuff but to no avail.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim LRow As Long
    
    If Target.Column = 2 Then
        LRow = Cells(Rows.Count, 5).End(xlUp).Row
        With Range("D" & Target.Row, "BE" & Target.Row)
            
            With .Borders(xlInsideVertical)
                .LineStyle = xlDash
                .Weight = xlThin
                .ColorIndex = xlAutomatic
            End With
            
        End With
    End If
End Sub