Export (0) Print
Expand All
Expand Minimize

Range.Borders Property

Office 2007
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").Borders(xlEdgeBottom)
        .LineStyle = xlContinuous
        .Weight = xlThin
        .ColorIndex = 3
    End With

End Sub



Community Additions

ADD
Show:
© 2015 Microsoft