Column Object

Microsoft Publisher Visual Basic

Column Object

Columns column
CellRange

Represents a single table column. The Column object is a member of the Columns collection. The Columns collection includes all the columns in a table, selection, or range.

Using the Column object

Use Columns(index), where index is the column number, to return a single Column object. The index number represents the position of the column in the Columns collection (counting from left to right). This example selects column three in the first shape in the active publication. This example assumes the first shape is a table and not another type of shape.

Sub SelectColumn()
    ActiveDocument.Pages(2).Shapes(1).Table.Columns(3).Cells.Select
End Sub
		

Use the Item method of a Columns collection to return a Column object. This example enters text into the first cell of the third column of the specified table and formats the text with a bold, 15-point font. This example assumes the first shape is a table and not another type of shape.

Sub ColumnHeading()
    With ActiveDocument.Pages(2).Shapes(1).Table.Columns(3) _
            .Cells(1).Text
        .Text = "Sales"
        .Font.Bold = msoTrue
        .Font.Size = 15
    End With
End Sub
		

Use the Delete method to delete a column from a table. This example deletes the column added in the above example.

Sub DeleteColumn()
    ActiveDocument.Pages(2).Shapes(1).Table.Columns(3).Delete
End Sub