Excel Developer Help

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

expression.Item(Index)

expression A variable that represents a Borders object.

Parameters

Name	Required/Optional	Data Type	Description
Index	Required	XlBordersIndex	One of the constants of XlBordersIndex.

Remarks

XlBordersIndex can be one of these XlBordersIndex constants.

xlDiagonalDown

xlDiagonalUp

xlEdgeBottom

xlEdgeLeft

xlEdgeRight

xlEdgeTop

xlInsideHorizontal

xlInsideVertical

Example

This following example sets the color of the bottom border of cells A1:G1.

Visual Basic for Applications
`Worksheets("Sheet1").Range("a1:g1"). _ Borders.Item(xlEdgeBottom).Color = RGB(255, 0, 0)`