Skip to main content

XlBordersIndex enumeration

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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>