Hello,

I'm looking for a vba that can help you draw a bottom border starting from row B8:S8 to the last item in column B. I know this could be a basic vba but what I have was not working.

Sub Test()

Dim LRow As Long

LRow = range("B" & Rows.Count).End(xlUp).Row

With range("B" & LRow
.Borders(xlEdgeTop).Weight = xlThin
.Borders(xlEdgeBottom).Weight = xlThin

End With

End Sub