CellRange Members (Publisher)

Article
05/04/2016

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

A collection of Cell objects in a table column or row. The CellRange collection represents all the cells in the specified column or row.

Methods

Name	Description
Item	Returns an individual Cell object in the specified CellRange collection.
Merge	Merges the specified table cells with one another. The result is a single table cell.
Select	Selects the specified object.

Properties

Name	Description
Application	Used without an object qualifier, this property returns an Application object that represents the current instance of Publisher. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object. When used with an OLE Automation object, it returns the object's application.
Column	Returns a Long that represents the table column containing the specified cell. Read-only.
Count	Returns a Long that represents the number of items in the specified collection.
Height	Returns a Long that represent the height (in cells) of a table, range of cells, or page. Read-only.
Parent	Returns an object that represents the parent object of the specified object. For example, for a TextFrame object, returns a Shape object representing the parent shape of the text frame. Read-only.
Row	Returns a Long that represents the row number containing the specified cell. Read-only.
Width	Returns a Long that represent the width (in cells) of a table, range of cells, or page. Read-only.