Borders Borders Borders Interface

Definition

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

public interface class Borders : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("00020855-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Borders : System.Collections.IEnumerable
Public Interface Borders
Implements IEnumerable
Attributes
Implements

Remarks

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.

Properties

_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.

Methods

GetEnumerator() GetEnumerator() GetEnumerator()

Applies to