This documentation is archived and is not being maintained.

Border Interface

Represents the border of an object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[InterfaceTypeAttribute()]
[GuidAttribute("00020854-0000-0000-C000-000000000046")]
public interface Border

Most bordered objects (all except for the Range and Style objects) have a border that’s treated as a single entity, regardless of how many sides it has. The entire border must be returned as a unit. Use the Border property to return the Border object for this kind of object.

Range and Style objects have four discrete borders — left, right, top, and bottom — that can be returned individually or as a group. Use the Borders property of a Range or Style object to return the Borders collection, which contains all four borders and treats the borders as a unit.

Use Borders(index), where index identifies the border, to return a single Border object.

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

Show: