Export (0) Print
Expand All
Expand Minimize

NamedRange.Borders Property

Gets a Borders collection that represents the borders of the NamedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Borders Borders { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Borders
A Borders collection that represents the borders of the NamedRange control.

The following code example uses the Borders property to draw double lines for the border of a NamedRange, and it uses the Interior property to color the interior of a NamedRange green.

This example is for a document-level customization.

Microsoft.Office.Tools.Excel.NamedRange bordersRange;
private void SetBordersAndInterior()
{
    bordersRange = this.Controls.AddNamedRange(
        this.Range["B2", "D4"], "namedRange1");
    this.bordersRange.Borders.LineStyle =
        Excel.XlLineStyle.xlDouble;
    this.bordersRange.Interior.Color = 0xFF00;
}

Show:
© 2015 Microsoft