Range.Borders Property

  • Article
Excel Developer Reference

Returns a Borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).

Syntax

expression.Borders

expression   A variable that represents a Range object.

Example

This example sets the color of the bottom border of cell B2 on Sheet1 to a thin red border.

Visual Basic for Applications 
  Sub SetRangeBorder()

With Worksheets("Sheet1").Range("B2").<strong>Borders</strong>(xlEdgeBottom)
    .LineStyle = xlContinuous
    .Weight = xlThin
    .ColorIndex = 3
End With



End Sub

See Also