PrintTitleRows 属性 (Excel) PageSetupPageSetup.PrintTitleRows property (Excel)

返回或设置包含要在每页顶部重复显示的单元格的行, 以宏语言的 A1 样式表示法中的字符串形式返回。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. 读/写 StringRead/write String.

语法Syntax

表达式PrintTitleRowsexpression.PrintTitleRows

_表达式_一个代表**PageSetup** 对象的变量。expression A variable that represents a PageSetup object.

说明Remarks

如果仅指定行的一部分,Microsoft Excel 将把该区域扩展为整个行。If you specify only part of a row or rows, Microsoft Excel expands the range to full rows.

将该属性设置为 False 或空字符串 (""),将会关闭标题行。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

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.