Border Border Border Interface


Represents the border of an object.

public interface class Border
public interface Border
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.


Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Color Color Color

Returns or sets the primary color of the border.

ColorIndex ColorIndex ColorIndex

Returns or sets the color of the border.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

LineStyle LineStyle LineStyle

Returns or sets the line style for the border.

Parent Parent Parent

Returns the parent object for the specified object.

ThemeColor ThemeColor ThemeColor

Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write Object.

TintAndShade TintAndShade TintAndShade

Returns or sets a Single that lightens or darkens a color.

Weight Weight Weight

Returns or sets the weight of the border.

Applies to