Weight Property

Applies To

Border object, Borders collection object, LineFormat object.

Description

Returns or sets the weight of the border. Can be one of the following XlBorderWeight constants: xlHairline, xlThin, xlMedium, or xlThick. Read/write Long.

Example

This example sets the border weight for oval one on Sheet1.

Worksheets("Sheet1").Ovals(1).Border.Weight = xlMedium