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
Bookmarks