Class CellRange (PowerPoint VBA)

A collection of Cell objects in a table column or row. The CellRange collection represents all the cells in the specified column or row. To use the CellRange collection, use the Cells keyword. To use a CellRange class variable it first needs to be instantiated, for example

Dim cre as CellRange
Set cre = ActiveWindow.RangeFromPoint.Table.Rows(1).Cells

Borders

Returns a Borders collection that represents the borders and diagonal lines for the specified Cell object or CellRange collection.

Dim brdsBorders As Borders
Set brdsBorders = ActivePresentation.Slides(1).Shapes(2).Table.Rows(1).Cells(1).Borders

Count

Returns the number of objects in the specified collection.

Dim lngCount As Long
lngCount = ActivePresentation.Slides(1).Shapes(2).Table.Rows(1).Cells.Count

Item

Returns a single Cell object from the specified CellRange collection.

Item (Index)

Index: The index number of the single Cell object in the collection to be returned.

Dim cllCellRange As Cell
Set cllCellRange = ActiveWindow.RangeFromPoint.Table.Rows(1).Cells(Index:=1)