A collection of objects that represent the borders and diagonal lines of a cell or range of cells in a table.

Remarks

Each Cell object or CellRange collection has six elements in the Borders collection. You cannot add objects to the Borders collection.

Use Borders(index), where index identifies the cell border or diagonal line, to return a single Border object. Index can be any PPBorderType constant.

PPBorderType can be one of these PPBorderType constants.
ppBorderBottom
ppBorderLeft
ppBorderRight
ppBorderTop
ppBorderDiagonalDown
ppBorderDiagonalUp

Example

Use the property to apply a dashed line style to a Border object. This example selects the second row from the table and applies a dashed line style to the bottom border.

Visual Basic for Applications 
ActiveWindow.Selection.ShapeRange.Table.Rows(2) _ .Cells.Borders(ppBorderBottom).DashStyle = msoLineDash

See also: