Edit

Share via


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]

Reserved for internal use.

Application

Returns an Application object that represents the Microsoft Excel application.

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

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

Count

Returns the number of objects in the collection.

Creator

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

Item[XlBordersIndex]

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

LineStyle

Returns or sets the line style for the border.

Parent

Returns the parent object for the specified object.

ThemeColor

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

TintAndShade

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

Value

Returns or sets the line style for the border.

Weight

Returns or sets the weight of the border.

Methods

GetEnumerator()

Applies to