XlBordersIndex enumeration (Excel)
Specifies the border to be retrieved.
| Name | Value | Description |
|---|---|---|
| xlDiagonalDown | 5 | Border running from the upper-left corner to the lower-right of each cell in the range. |
| xlDiagonalUp | 6 | Border running from the lower-left corner to the upper-right of each cell in the range. |
| xlEdgeBottom | 9 | Border at the bottom of the range. |
| xlEdgeLeft | 7 | Border at the left edge of the range. |
| xlEdgeRight | 10 | Border at the right edge of the range. |
| xlEdgeTop | 8 | Border at the top of the range. |
| xlInsideHorizontal | 12 | Horizontal borders for all cells in the range except borders on the outside of the range. |
| xlInsideVertical | 11 | Vertical borders for all the cells in the range except borders on the outside of the range. |
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.