Returns or sets the weight of the border. Read/write XlBorderWeight.

[Visual Basic]
Property Weight As XlBorderWeight
[C#]
XlBorderWeight Weight { get; set; }
[C++]
__property XlBorderWeight get_Weight();
__property void set_Weight(XlBorderWeight );
[JScript]
function get Weight() : XlBorderWeight
function set Weight(XlBorderWeight);

Example

This example sets the weight of border around the A1:C5 range.

[C#]
IBorders borders = book.Worksheets[1].Range["A1:C5"].Borders;
borders[XlBordersIndex.xlEdgeTop].Weight    = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlEdgeBottom].Weight = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlEdgeLeft].Weight   = XlBorderWeight.xlThin;
borders[XlBordersIndex.xlEdgeRight].Weight  = XlBorderWeight.xlThin;

[Visual Basic]
Dim borders As IBorders = book.Worksheets(1).Range("A1:C5").Borders
borders(XlBordersIndex.xlEdgeTop).Weight    = XlBorderWeight.xlThin
borders(XlBordersIndex.xlEdgeBottom).Weight = XlBorderWeight.xlThin
borders(XlBordersIndex.xlEdgeLeft).Weight   = XlBorderWeight.xlThin
borders(XlBordersIndex.xlEdgeRight).Weight  = XlBorderWeight.xlThin

[C++]
IBorders* borders = book->Worksheets->Item[1]->Range->Item[S"A1:C5"]->Borders;
borders->Item[XlBordersIndex::xlEdgeTop]->Weight    = XlBorderWeight::xlThin;
borders->Item[XlBordersIndex::xlEdgeBottom]->Weight = XlBorderWeight::xlThin;
borders->Item[XlBordersIndex::xlEdgeLeft]->Weight   = XlBorderWeight::xlThin;
borders->Item[XlBordersIndex::xlEdgeRight]->Weight  = XlBorderWeight::xlThin;

This example is the same as the previous.

[C#]
book.Worksheets[1].Range["A1:C5"].Borders[XlBordersIndex.xlAround].Weight = XlBorderWeight.xlThin; 

[Visual Basic]
book.Worksheets(1).Range("A1:C5").Borders(XlBordersIndex.xlAround).Weight = XlBorderWeight.xlThin 

[C++]
IBorders* borders = book->Worksheets->Item[1]->Range->Item[S"A1:C5"]->Borders;
borders->Item[XlBordersIndex::xlAround]->Weight = XlBorderWeight::xlThin; 

See Also

IBorder Interface | NativeExcel Namespace | XlBorderWeight Enumeration | IRange.Borders Property | IBorders Interface

---