CellRange Collection Object

Multiple objects CellRange Borders

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.

Using the CellRange Collection

Use the Cells property to return the CellRange collection. This example sets the right border for the cells in the first column of the table to a dashed line style.

With ActivePresentation.Slides(2).Shapes(5).Table.Columns(1).Cells
    .Borders(ppBorderRight).DashStyle = msoLineDash
End With

This example returns the number of cells in row one of the selected table.

num = ActiveWindow.Selection.ShapeRange.Table.Rows(1).Cells.Count

Use Cell(row, column), where row is the row number and column is the column number, or Cells(index), where index is the number of the cell in the specified row or column, to return a single Cell object. Cells are numbered from left to right in rows and from top to bottom in columns. With right-to-left language settings, this scheme is reversed. The example below merges the first two cells in row one of the table in shape five on slide two.

With ActivePresentation.Slides(2).Shapes(5).Table
    .Cell(1, 1).Merge MergeTo:=.Cell(1, 2)
End With

Remarks

Although the collection object is named CellRange and is shown in the Object Browser, this keyword is not used in programming the PowerPoint object model. The keyword Cells is used instead.

You cannot programmatically add cells to or delete cells from a PowerPoint table. Use the AddTable method with the Table object to add a new table. Use the Add method of the Columns or Rows collections to add a column or row to a table. Use the Delete method of the Columns or Rows collections to delete a column or row from a table.

Properties | Application Property | Borders Property | Count Property | Parent Property

Methods | Item Method

Parent Objects | Column Object | Row Object

Child Objects | Borders Object

See Also | Cell Method | Cells Property | Column Object | Columns Collection Object | Rows Collection Object | Working with Tables