Share via


NamedRange.BorderAround2 Method

Definition

Adds a border to a NamedRange control and sets the Color, LineStyle, and Weight properties for the new border.

public object BorderAround2 (object LineStyle, Microsoft.Office.Interop.Excel.XlBorderWeight Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin, Microsoft.Office.Interop.Excel.XlColorIndex ColorIndex = Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, object Color, object ThemeColor);
abstract member BorderAround2 : obj * Microsoft.Office.Interop.Excel.XlBorderWeight * Microsoft.Office.Interop.Excel.XlColorIndex * obj * obj -> obj
Public Function BorderAround2 (Optional LineStyle As Object, Optional Weight As XlBorderWeight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin, Optional ColorIndex As XlColorIndex = Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, Optional Color As Object, Optional ThemeColor As Object) As Object

Parameters

LineStyle
Object

The line style for the border. Can be one of the following XlLineStyle values: xlContinuousxlDashxlDashDotxlDashDotDotxlDotxlDoublexlSlantDashDotxlLineStyleNone

Weight
XlBorderWeight

The border weight. Can be one of the following XlBorderWeight constants: xlHairlinexlMediumxlThickxlThin

ColorIndex
XlColorIndex

The border color, as an index into the current color palette or as an XlColorIndex constant. Can be one of the following XlColorIndex constants: xlColorIndexAutomaticxlColorIndexNone

Color
Object

The border color, as an RGB value.

ThemeColor
Object

The theme color, as an index into the current color theme or as an XlThemeColor value.

Returns

Remarks

You must specify either ColorIndex or Color, but not both.

You can specify either LineStyle or Weight, but not both. If you do not specify either argument, Microsoft Office Excel uses the default line style and weight.

This method outlines the entire range without filling it in. To set the borders of all the cells, you must set the Color, LineStyle, and Weight properties for the Borders collection. To clear the border, you must set the LineStyle property to xlLineStyleNone for all the cells in the range.

Applies to