Applies To
PageSetup Object.
Description
Returns or sets the rows containing the cells to be repeated on the top 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 row or rows, Microsoft Excel expands the range to full rows.
Set this property to False or to the empty string ("") to turn off title rows.
This property applies only to worksheet pages.
See Also
PrintTitleColumns 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