Multiple objects
Borders
LineFormatColorFormatA collection of LineFormat objects that represent the borders and diagonal lines of a cell or range of cells in a table.
Using the Borders Collection
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 |
Use the DashStyle 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.
ActiveWindow.Selection.ShapeRange.Table.Rows(2) _
.Cells.Borders(ppBorderBottom).DashStyle = msoLineDash