This documentation is archived and is not being maintained.

XlBordersIndex Enumeration

Office 2007
Specifies the border to be retrieved.
NameValueDescription
xlDiagonalDown5Border running from the upper left-hand corner to the lower right of each cell in the range.
xlDiagonalUp6Border running from the lower left-hand corner to the upper right of each cell in the range.
xlEdgeBottom9Border at the bottom of the range.
xlEdgeLeft7Border at the left-hand edge of the range.
xlEdgeRight10Border at the right-hand edge of the range.
xlEdgeTop8Border at the top of the range.
xlInsideHorizontal12Horizontal borders for all cells in the range except borders on the outside of the range.
xlInsideVertical11Vertical borders for all the cells in the range except borders on the outside of the range.


Show: