Class Points (Excel VBA)

A collection of all the Point objects in the specified series in a chart. To use a Points class variable it first needs to be instantiated, for example

Dim pnts as Points
Set pnts = ActiveCell.Width

Count

Returns a Long value that represents the number of objects in the collection.

Dim lngCount As Long
lngCount = ActiveCell.Width.Count

Item

Returns a single object from a collection.

Item (Index)

Index: The index number for the object.

Dim pnt As Point
Set pnt = ActiveCell.Width(Index:=1)