TableStyleElement.Borders Property (Excel)

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

Version Added: Excel 2007

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:
© 2014 Microsoft