XlBordersIndex Enumeration

Specifies the border to be retrieved.

Name

Value

Description

xlDiagonalDown

5

Border running from the upper left-hand corner to the lower right of each cell in the range.

xlDiagonalUp

6

Border running from the lower left-hand 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-hand edge of the range.

xlEdgeRight

10

Border at the right-hand 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.