PageSetup.PrintTitleColumns Property

Syntax

expression.PrintTitleColumns

expression A variable that represents a PageSetup object.

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.

Example

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

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

Find out the source of row titles? Print a label at the beginning of each row on each page? Print the same row label on every page? print title columns Print Title Columns Property printtitle PrintTitleColumns PrintTitleColumns Property PrintTitleColumns?

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

See also: