Borders Borders Borders Interface


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

public interface class Borders : System::Collections::IEnumerable
public interface Borders : System.Collections.IEnumerable
Public Interface Borders
Implements IEnumerable


Use the Borders property of a Range or Style object to return the Borders collection, which contains all four borders.

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.


_Default[XlBordersIndex] _Default[XlBordersIndex] _Default[XlBordersIndex]

Reserved for internal use.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Color Color Color

Returns or sets the primary color of all four borders of a range. If they're not all the same color, returns 0 (zero).

ColorIndex ColorIndex ColorIndex

Returns or sets the color of all four borders. Returns Null if all four borders aren't the same color.

Count Count Count

Returns the number of objects in the collection.

Creator Creator Creator

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

Item[XlBordersIndex] Item[XlBordersIndex] Item[XlBordersIndex]

Returns a Border object that represents one of the borders of either a range of cells or a style.

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.

Value Value Value

Returns or sets the line style for the border.

Weight Weight Weight

Returns or sets the weight of the border.


GetEnumerator() GetEnumerator() GetEnumerator()

Applies to