PrintTitleColumns Property

Applies To

PageSetup Object.

Description

Returns or sets the columns containing the cells to be repeated on the left of each page, as a string in A1-style notation in the language of the macro. Read-write.

Remarks

If you specify only part of a column or columns, Microsoft Excel expands the range to full columns.

Set this property to False or to the empty string ("") to turn off title columns.

This property applies only to worksheet pages.

See Also

PrintTitleRows Property.

Example

This example defines row three as the title row, and it defines columns one through three as the title columns.

Worksheets("Sheet1").Activate
ActiveSheet.PageSetup.PrintTitleRows = ActiveSheet.Rows(3).Address
ActiveSheet.PageSetup.PrintTitleColumns = _
        ActiveSheet.Columns("A:C").Address