TableStyleElement.Borders Property (Excel)
Returns a Borders collection that represents the borders of a table style element. Read-only.
Version Information
Version Added: Excel 2007
Syntax
expression .Borders
expression A variable that represents a TableStyleElement object.
Example
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