Search Office
Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2007 > Excel 2007 > Excel 2007 Developer Reference > Excel Object Model Reference > Borders Object > Borders Collection
1 out of 1 rated this helpful - Rate this topic

Borders Collection

Office 2007
A collection of four Border objects that represent the four borders of a Range or Style object.

Remarks

Use the Borders property to return the Borders collection, which contains all four borders.

You can set border properties for an individual border only with Range and Style objects. Other bordered objects, such as error bars and series lines, have a border that’s treated as a single entity, regardless of how many sides it has. For these objects, you must return and set properties for the entire border as a unit. For more information, see the Border object.

Example
The following example adds a double border to cell A1 on worksheet one.

Visual Basic for Applications
Worksheets(1).Range("A1").Borders.LineStyle = xlDouble

Use Borders(

index), where index identifies the border, to return a single Border object. The following example sets the color of the bottom border of cells A1:G1 to red.
Visual Basic for Applications
Worksheets("Sheet1").Range("A1:G1"). _
    Borders(xlEdgeBottom).Color = RGB(255, 0, 0)

Index can be one of the following xlBordersIndex constants: xlDiagonalDown, xlDiagonalUp, xlEdgeBottom, xlEdgeLeft, xlEdgeRight, or xlEdgeTop, xlInsideHorizontal, or xlInsideVertical.

See Also


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.