Skip to content

Latest commit

 

History

History
49 lines (29 loc) · 1.22 KB

Excel.PageSetup.PrintTitleRows.md

File metadata and controls

49 lines (29 loc) · 1.22 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PageSetup.PrintTitleRows property (Excel)
vbaxl10.chm473098
vbaxl10.chm473098
Excel.PageSetup.PrintTitleRows
de01a1a9-a6f5-9eb4-5785-2993475c1a02
05/03/2019
medium

PageSetup.PrintTitleRows property (Excel)

Returns or sets the rows that contain the cells to be repeated at the top of each page, as a String in A1-style notation in the language of the macro. Read/write String.

Syntax

expression.PrintTitleRows

expression A variable that represents a PageSetup object.

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.

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

[!includeSupport and feedback]