XlBordersIndex Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

Show: