Sub SetRangeBorder() With Worksheets("Sheet1").Range("B2").Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 3 End With End Sub