TableStyleElement.Borders Property (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.

Returns a Borders collection that represents the borders of a table style element. Read-only.

expression .Borders

expression A variable that represents a TableStyleElement object.

This example sets the color of the top border of a table to red.

With ActiveWorkbook.TableStyles("Table Style 4").TableStyleElements( _ 
 xlWholeTable).Borders(xlEdgeTop) 
 .Color = 255 
 .TintAndShade = 0 
 .Weight = 2 
 .LineStyle = 1 
End With
Show: