Cell Members (Publisher)

GitHub-Mark-64px

Contribute to this content

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

Represents a single table cell. The Cell object is a member of the CellRange collection. The CellRange collection represents all the cells in the specified object.

Methods

Name

Description

Merge

Merges the specified table cell with another cell. The result is a single table cell.

Select

Selects the specified object.

Split

Splits a merged table cell back into its constituent cells. Returns a CellRange object representing the constituent cells.

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.

BorderBottom

Returns a CellBorder object that represents the bottom border for a specified table cell.

BorderDiagonal

Returns a CellBorder object that represents the diagonal border for a specified table cell.

BorderLeft

Returns a CellBorder object that represents the left border for a specified table cell.

BorderRight

Returns a CellBorder object that represents the right border for a specified table cell.

BorderTop

Returns a CellBorder object that represents the top border for a specified table cell.

CellTextOrientation

Returns or sets a PbTextOrientation that represents the flow of text in a specified table cell. Read/write.

Column

Returns a Long that represents the table column containing the specified cell. Read-only.

Diagonal

Sets or returns a PbCellDiagonalType constant that represents a cell that is diagonally split. Read/write.

Fill

Returns a FillFormat object representing the fill for the specified shape or table cell.

HasText

Returns a Boolean value indicating whether the specified cell contains any text. ReturnsTrue if the specified cell contains text. Read-only.

Height

Returns a Long that represent the height (in cells) of a table, range of cells, or page. Read-only.

MarginBottom

Returns or sets a Variant that represents the amount of space (in points) between the text and the bottom edge of a cell, text frame, or page. Read/write.

MarginLeft

Returns or sets a Variant that represents the amount of space (in points) between the text and the left edge of a cell, text frame, or page. Read/write.

MarginRight

Returns or sets a Variant that represents the amount of space (in points) between the text and the right edge of a cell, text frame, or page. Read/write.

MarginTop

Returns or sets a Variant that represents the amount of space (in points) between the text and the top edge of a cell, text frame, or page. Read/write.

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.

Selected

Returns True if a cell is selected. Read-only Boolean.

TextRange

Returns a TextRange object that represents the text that is attached to a shape and properties and methods for manipulating the text.

VerticalTextAlignment

Returns or sets a PbVerticalTextAlignmentType constant that represents the vertical alignment of text in a text box. Read/write.

Width

Returns a Long that represent the width (in cells) of a table, range of cells, or page. Read-only.