border or borders?

[lezawang]

Hi
I thought Borders, is a properties of Range object and its data type is Borders. So the in MS page it says the follwing (without s)

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

https://docs.microsoft.com/en-us/office/vba/api/excel.border.weight

Thank you.

 

[JoeMo]

The Oval is a shape object not a range object. Unlike the range object, the border of a shape object is treated as a single entity, regardless of the number of sides it has. Range objects have multiple sides which requires a borders property.